Mike,
The formula you wrote is for one cell. If I want to apply this formula to
whole column, should I replace A1 with A1:A5000? Thank you for the help.

Loc

"Mike H" wrote:

Hi,

For closer than 30 try
=AND(A1<TODAY()+30,A1=TODAY())

and for overdue
=A1<TODAY()

Mike

"Loc" wrote:

I have a delivery date column with mmm-yy format. How can I write a
conditional formula so that the date turns yellow when it's due in 30 days
and turns red when it's over due? Please help!