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.

On Jul 16, 4:01*pm, DRKENNE wrote:
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.

Maybe an example, with more information? Where is it caluclating the
null or zero from?
Try this.

Cell W1 = 07/20/09
Formula in G1 is =IF(H1="","",$W$1-H1)
Conditional formating in G1 is "Cell Value is" - "equal to" - "0"
Format your color in the format section
Select G1 and fill down column G your desired area.
Place a date in Column H to generate a number in G

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.



--

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.



--

On Jul 20, 9:07*am, DRKENNE wrote:
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?



If the cell is truly blank,
Enter your "conditional formatting" as follows in cell "G1" and fill
down.
Enter as: Format Conditional Formatting choose "Formula is" from
the drop down the formula in conditional formatting is entered as,

=ISBLANK(G1)

Select your color/pattern, and then "fill down" your column. This
will color your "Blank" cells.