Conditional Formatting with dates

[TAKIS]

Dear all hello,

I am trying to add conditional formatting in one of my columns as follows:

1)when the date in column A passed the today's date and there is no date in column B - turn the cell red - i used the following formula:=A2<today()

2)when the date in column A is greater then today's date and there is no date in column B - the cell remains with no colour

3)when I add a date in column B (either less or higher) I would like cell A to turn green from either red colour (1) or no colour (2).

And it is that last step I do which I cant make right. I can make it work (and a cell will turn green) only when date in column A is less than the date in column B. But, when the date in column A is greater than the date in column B then it still remains red.

Any comments/advice on the functions I have to use would be greatly appreciated.

Thank you very much for your time!</today()

 

[Jubjab]

Conditional formatting rule for cell A2

1: =A2<TODAY()   --> fill red
2: =b2>0             --> fill green

 

[Jubjab]

sorry, the forum is screwing up again, first rule should be if a2 is less than today then fill red