Conditional Formatting - Inconsistently Displayed

[Robin]

I have applied conditional formatting to a cells so that
if the date in the cell is prior to today's date, the text
will display in RED. However, not all cells with a date
prior to today's date are displaying in RED.

Cell format: Date - mm/dd/yy
Conditional formatting: Cell value > is less than > 37889

format > red/bold

Version: Excel 97

Im sure this must be an easy fix... Thanx for any ideas.

 

[fredg]

I have applied conditional formatting to a cells so that
if the date in the cell is prior to today's date, the text
will display in RED. However, not all cells with a date
prior to today's date are displaying in RED.

Cell format: Date - mm/dd/yy
Conditional formatting: Cell value > is less than > 37889

Version: Excel 97

Im sure this must be an easy fix... Thanx for any ideas.

You will get a better chance of a useful reply by posting your message
in an Excel Newsgroup.
The Access in this newsgroup's title refers to Microsoft Access, a
database product.

Good luck.

 

[Gina]

You might want to post your question to an Excel newsgroup
this is for Microsoft Access a database product..