Conditional Formatting +-4 days

Hello,

I have a scenario that tracks patient contact dates. The client has a 8 day window in which they want to contact a patient about a followup visit.

There are 4 criteria:

1. Color the cell yellow if today's date is within 4 days before the date in that cell.
2. Color the cell green if today's date is the same as the date in that cell.
3. Color the cell pink if today's date is up to 4 days after the date in that cell.
4. If today's date is over 4 days after the date in that cell, make the cell color red.

I've been looking but not finding anything close to that. I'm just learning Excel, so, I don't have lots of experience...but, I've watched videos on YouTube and searched here.

Any assistance would be greatly appreciated.

Thanks,

Dalmuti (Louise)

Hi TMS,

The workbook is all sample data. I have 4 tabs. I highlighted the dates on tab Site123. I'd hope I can figure out how to do the same thing on the other sheets.

Tracker.xlsx

I hope the attachment worked.

Thanks,

Louise

Microsoft Excel for Mac 2010

Thanks,
Louise

Thanks OllyXLS and TMS - that was enough to get me going.

Thanks so much,

Louise