if, dates and cell color changes.

  • Thread starter Thread starter Sophia
  • Start date Start date
S

Sophia

Can you make an if statement usignthe date so that if the
title of the column is Dedline and the date listed has
past, then the cell automatically changes to a different
color to indicate past do.
 
Sounds like you need a conditional format. Something along the lines of:

=AND((A1<TODAY()),NOT(ISBLANK(A1)))
 
Back
Top