Conditional Formatting by date.

[chiinacaat]

Hello all. This is my first post and I apologize if this question has already been asked, but I couldn't find it.

I'm building a spread sheet to track when employee’s performance reviews are due. I want the cell to turn blue when the date in the cell is 30 days from now. Then it turns green when the date is from today through 30 days over due. Then Yellow when it's 31-60 days overdue. Then red when it's over 60 days late. If the dates aren't in those ranges I want the cells to not have any color.

Thanks so much in advance.

[Palmetto]

See if the attached works for you.