I have been searching but i cant solve my issue,
I want to conditional format a cell that will be either, Green, Yellow or red depending on the date
If the date i enter in cell G9 is more than 60 days from today the cell should be green
if the date is less than 60 days from today the cell should be yellow
if the cell is less than 30 days from today the cell should be red
This is for drivers licence dates, i want to be alerted when they are 60 days from the expiration etc

E.G todays date 4/10/15
I have a date 6/10/15 the cell should be yellow
I have a date 5/10/15 the cell should be red
I hope im making sense here!