T
Todd
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.
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.