Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Colour-coding a cell from a drop down list
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I copy format (eg colour of cells) in a drop down list | Excel Worksheet Functions | |||
Drop down list - color coding | Excel Worksheet Functions | |||
Colour coded drop down list | Excel Discussion (Misc queries) | |||
How do I change the text colour in a drop down list? | Excel Discussion (Misc queries) | |||
Colour of the Text in a drop box list I have ... | Excel Discussion (Misc queries) |