Colour-coding a cell from a drop down list

[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

 

[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?