Colour-coding a cell from a drop down list
Excel versions prior to xl2007 had a maximum of 3 conditions in conditional
format. therefore the following questions.
What version of xl are you using? (If xl2007 then discard the next 2
questions.)
How many color options do you want?
Do you want VBA macro code if using xl version prior to xl2007 and you need
more than 3 color options?
If you want VBA code, do you need instructions to copy the code into your
workbook?
--
Regards,
OssieMac
"Kellmmm" wrote:
how do i program a cell that has a drop down list, to be colour coded
depending on what item is selected from list?
For example. If some picks the item 'Open' from a drop-down list, i want the
cell to change to blue or have blue shading
|