I have created a simple database in Excel. In this database I have a need to introduce formatting using VBA to allow for conditional formatting. The function provided in Excel allows for only 3 levels or conditions. E.G. Cells AC14:AC18, AG14:AG18, AI14:AI18, AK14:AK18, AM14:AM18, AO14:AO:18, AQ14:AQ18, AS14:AS18, AND AU14:AU18 all contain identical VALIDATED lists. Cells AM:AS(25:29) contain individual names per cell that need to change background color once selected from the above drop-down lists. Additionally, I need the names to disappear from all drop-down lists once selected in ANY of the cells ranging from AC14:AC18 through AU14:AU18. Please quote for the code written and instructions on using once completed.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows XP Office XP Excel XP (2002) IE 6.0 xpsp1.02...