if, dates and cell color changes.

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

 

[Dave Smith]

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

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