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