conditional formatting for future dates

**just_tonight** · 04-05-2011, 01:20 PM

Hello,

Sorry for a possible repeat question...

I am trying to format a column of dates so that if 30 days from the date in the cell is equal to or later than today's date, the cell highlights red.

So for today's date (4/5/2011), any cells with 3/5/2011 or before would be red.

Thanks in advance!!

**Marcol** · 04-05-2011, 01:35 PM

Try this

Select your column say Column A

Conditional formatting
Formula is :=

=AND($A1<=TODAY()+30,$A1>=TODAY())

Hope this helps

**just_tonight** · 04-05-2011, 01:44 PM

Sorry! I was in such a rush that my thread title was wrong! I need help with the past, not future.

That formula highlights all dates for the next 30 days. I need to highlight all dates 30 days or more before today.

**Marcol** · 04-05-2011, 01:52 PM

Change the formula in the C/f to

=AND($A1>=TODAY()-30,$A1<=TODAY())

Hope that is okay now.

**just_tonight** · 04-05-2011, 02:41 PM

That one highlights the previous 30 days... I need 30 or more days before today's date highlighted.

I tried tweaking the formula you gave me so I wouldn't have to ask again... but I can't figure it out