format cell if date not current

  • Thread starter Thread starter Becky
  • Start date Start date
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?
 
Conditional Formatting (Format->Conditional Formatting) should be the
best thing.

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

Format... (change font color to Red)
 
Format/ Conditional Formatting/ Cell Value Is/ Less than/ =TODAY()
Choose your red format.
 
Back
Top