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.



--