if, dates and cell color changes.

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

Dave Smith

Sounds like you need a conditional format. Something along the lines of:

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