" wrote:
This doesn't seem to work for the dropdown (list) in column E. If
there's a date that's more than 2 days older than today, it turns the
column yellow, however, if you then go back and select an entry in one
of the column E's listbox, it doesn't turn the line back to the normal
white.. it just stays yellow.

If you go back and *clear* the cell in col E using the Delete key, instead
of selecting the top line "space" from the DV droplist in col E, then CF will
work as expected -- the row will turn "white". This would be the simpler
route.

If you want it to work by selecting the top line "space" from the DV
droplist in col E, then adjust the CF conditions to:

Cond1: =AND($A20<"",$E20<" ",$A20+2<TODAY(),$L20="")
Cond2: =AND($A20<"",$E20<" ",$L20<"",$L20=$A20)

[I copied the "space" exactly from col E's DV source box and pasted it
within the "" in the CFs' former $E3<"" part]
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---