Conditional Formatting - Inconsistently Displayed

  • Thread starter Thread starter Robin
  • Start date Start date
R

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
Click to expand...

Version: Excel 97

Im sure this must be an easy fix... Thanx for any ideas.
 
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.
Click to expand...

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.
 
You might want to post your question to an Excel newsgroup
this is for Microsoft Access a database product..
 
Back
Top