there is no date (yet) in column G and the current date is in W1 (=today()).
What I'd like is for all cells in column g that have no date entered to have
a yet to be determined color. Does this make ssense or help?

"Liliana" wrote:

Since you did not state specifically in what circumstance you needed the
highlight applied nor where the conditional format was to obtain its
values, here are a few sample of conditional formatting formula. You
should be able to work out what you need using one of the samples as a
guide.


1) To set a date manually (example would highlight anything older than
7/7/2009:

=AND($G1<"",$W1<DATEVALUE("7/7/2009"))

2) To compare to a fixed cell (example would highlight anything older
than the date shown in A1:

=AND($G1<"",$W1<$A$1)


3) To compare to a dymanic date based on the PC date (example would
highlight anything older than 7 days if

=AND($G1<"",$W1<TODAY()-7)



--
Lil




?B?RFJLRU5ORQ==?= wrote in
:

I'd like to conditionally format a column (add color) based on the
date value in W1 and where cells in the column G are null.



--