Conditional formatting

  • Thread starter Thread starter DRKENNE
  • Start date Start date
D

DRKENNE

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.
 
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.
Click to expand...

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




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.
Click to expand...



--
 
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?
 
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?
Click to expand...


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.
 
Back
Top