format cell if date not current

B

Becky

I am trying to figure out if the date in a cell can be formatted to red if it
is a date that is prior to today's date.

Can this be done and if so, how?
 
G

google

Conditional Formatting (Format->Conditional Formatting) should be the
best thing.

"Formula Is" =(your cell)<today() <- evaluates to TRUE

Format... (change font color to Red)
 
D

David Biddulph

Format/ Conditional Formatting/ Cell Value Is/ Less than/ =TODAY()
Choose your red format.
 

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

Similar Threads

Display weeks from a Milestone 0
Date Conditional Formatting 4
Conditional formatting dates 3
Conditionally Format Particular Dates 1
Conditional Formatting - Cannot get it to work, please help 1
need help in creating a formula 1
Conditional Formatting question.... 1
Conditional Formatting Less Than Today Week Days only 0

Top