Conditional Formatting - Inconsistently Displayed


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

Version: Excel 97

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

Advertisements

F

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

Advertisements

G

Gina

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top