R
rerhart
I'm having a problem with a simple Conditional Format.
I have a column of dates and I want to have the cell highlight in re
if the date in the cell is less than today.
Example...
The date in my cell is 2/1/2003
Today's date is 8/5/2004
I apply a conditional format on the cell like this:
Format\Conditional Formating
Conditon 1: Formula Is - R2<TODAY()
Click OK.
Then I Format Pattern and pick the color Red.
Note that if I go back and look at it, it now looks like this:
Formula Is - ="R2<TODAY()"
My cell is not Red, but it should be with the dates above, correct?
Stumped..
I have a column of dates and I want to have the cell highlight in re
if the date in the cell is less than today.
Example...
The date in my cell is 2/1/2003
Today's date is 8/5/2004
I apply a conditional format on the cell like this:
Format\Conditional Formating
Conditon 1: Formula Is - R2<TODAY()
Click OK.
Then I Format Pattern and pick the color Red.
Note that if I go back and look at it, it now looks like this:
Formula Is - ="R2<TODAY()"
My cell is not Red, but it should be with the dates above, correct?
Stumped..