Conditional Formatting basic question

[{MC}]

Hi, my knowledge of excel is nowhere near where most of you are and I have a question about conditional formatting.

Lets say I have a cell with a date in it and if that date has passed I would like the cell to change to red. So I highlighted the date cells and selected conditional formatting, I filled in the dialog box so it was cell value is less than today() but no matter what date I put in there it changes to red.

I tried finding the answer myself but had no luck. Thanks

 

[smozgur]

Just create this condition in order:

Cell Value is - less than - =TODAY()

and set your format..

If you want to use a specific day as criteria then

Change

=TODAY()

to

=DATEVALUE("12/12/2001")

"12/12/2001" is my criteria.

Enjoy
suat
This message was edited by smozgur on 2002-03-16 16:48

 

[Dave Hawley]

Hi

Looks like you have your answer, but in addition you might be interested in an example Workbook download I have here:

http://www.ozgrid.com/download/default.htm It's the second from the bottom (OverDueDates.zip)

 

[{MC}]

Thanks for the help!

 

[smozgur]

Anytime.

suat