conditional format formula

[Guest]

I am trying to use a formula in conditional format to turn a cell grey if the
date in the column is not yet passed.


not colored not colored
should be grey
a b
c
10/20/04 10/21/04
10/22/04
5:00 5:00
5:00


=IF(NOW()<a$2,,) Is my formula. Whether I use < or > does not matter, the
formula doesn't work so I am not getting something!


TIA


Todd L.

 

[Guest]

Hi,

try using conditional format using A1<TODAY() and setting your pattern to
grey