Conditional formatting, with dates and blanks

[jjsweeney]

Hello everyone

I am currently setting up a project timeline, and at each stage i need the cell to change color depending on input. so for instance stage one happen -50 days. i work the date out need for completing and then the actual date is then put in the cell below which i want to go either

Green because it was done early or on time
Amber if it has been done but was late
Red if has not been done and the current date is now past the date of completion
Stay Blank if it is Blank and their is still time to do it

for the green i am using a A2 <=A1
Amber i am using A2 > A1
for the red i'm using =And(A2<Today(),A1="")

the red one conditioning does not seem to be working and if their is nothing in the cell an its within the time its going green !

[jjsweeney]

it looks like the below if that helps

Capture.PNG