Conditional Formatting with Dates

[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..

 

[Trevor Shuttleworth]

Take out the quotes (")

=R2<TODAY()

Regards

Trevor

 

[Leo Heuser]

In Formula is enter:
=R2<TODAY()

The equal-to sign is crucial.

 

[Earl Kiosterud]

The formula should be something that resolves to TRUE or FALSE.
="R2<TODAY()" is a string. No telling what it'll do with that.

Your formula is correct. You have to type the = in front of the boolean
(R2<TODAY()) statement, or it'll add the quotes, and become worthless.

And the active (white) cell of your selection should be R2 for this formula.

 

[Bill Kuunders]

try the simple version
use the dropdown boxes in conditional formatting
select <cell value>
select <less than>
enter today()
worked on this side of the world
good luck

Bill K

 

[Bill Kuunders]

enter =today()
not today()
now it works.........

Regards
Bill K

try the simple version
use the dropdown boxes in conditional formatting
select <cell value>
select <less than>
enter today()
worked on this side of the world
good luck

Bill K