I found a thread with conditional formulas that should be exactly what I need (with the same title) but something isn't working. I have played with the date format and the formula and am stuck. Formula doesn't seem to be recognizing date. It is highlighting all cells Yellow.

Condition 1: Highlight cell (column B) yellow if date is within 4 months from today
Formatting Rule: Format only cells that contain / Cell Value / Less than or equal to / ="today()+120

Stop If True

Condition 2: Highlight cell (column B) red if date is past today.
Formatting Rule: Format only cells that contain / Cell Value / Less than / ="today()"

Hopefully the file is attached.
ConditionalFormatting.xls

Thank you,
CindyCapture.JPGAttachment 382937