Colour-coding a cell from a drop down list

K

Kellmmm

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
 
O

OssieMac

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pick from drop-down list gives empty or erroneous result 6
How to dynamically change the list in drop down list based on thevalue of another cell? 1
Define the Range of a drop-down list 5
Referencing a Origin Cell from Data Validation 8
Cell Shading Colour Property 8
linking the selection of a drop-down list to a quanity in another 2
Help with creating drop down 1
Data Validation List problem 5

Top