In previous versions of Excel (i.e. 2003) you could create validation lists,
format each cell with a different color (e.g. red, green , and yellow) and
once the list was advertised in the desired cell and the value selected from
the drop down list that formatting was carried over to the cell of the
selected value. In 2007 it doesn't seem to work. Can anybody recommend what
I need to do to get this working?