Conditional Formatting To Highlight Upcoming Expiry Dates

[DLEEB]

I have a spreadsheet for new hires where I have a column for their start date and one for probation period end date. I have it set up so that the probation period end date automatically calculates 3 mos from start date. I would like to have the probation dates highlight when the date is 7 before probation date and 14 days before probation date. I used the conditional formatting using the cell value option but it doesn't seem to work. Any help would be greatly appreciated.

 

[lennywatson]

I have a similar situation (highlight expiring certifications for staff). In my case I highlight 30 days out in yellow, and past due in red. My conditional formatting rules are:
Cell Value < NOW() (red)
Cell Value < NOW()+30 (yellow)

So in your case it would be NOW()+7 and NOW()+14

For me it seems it's counting days; not sure why or how I would change that. Might have to do with the cell formatting?

Does that work for you?

 

[DLEEB]

Yes thank you.