Conditional Formatting with Dates

  • Thread starter Thread starter rerhart
  • Start date Start date
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..
 
Thanks, that helps. How do I copy that conditional format down m
column so that each cell reference changes accordingly?

..or, why doesn't the conditional format:

If Cell Value Is - Less Than - TODAY()

work for me
 
Select the cell containing the conditional format.
Click on the "FormatPainter" (yellow paint brush) icon on the tool bar.
Click and drag down as needed from the first cell that you wish to copy to.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================

Thanks, that helps. How do I copy that conditional format down my
column so that each cell reference changes accordingly?

..or, why doesn't the conditional format:

If Cell Value Is - Less Than - TODAY()

work for me?
 
Back
Top