Conditional formatting issue

[Stief1981]

Hello All,

I am looking for a formula that can help me out with the following conditional formatting:
In my excel sheet I have 3 dates wich should determine the color of a cell.

Cell G3 on sheet 1 needs to change color in following cases:
1. date in F3 is older the date today in B1 AND G3 is empty → RED
2. date in G3 is higer than F3 → ORANGE → this seems easy // =IF(G3>F3;TRUE;FALSE)

For the second one I think I have found it but for the first on I thought this was :
=IF(AND(ISBLANK(G3);F3>$B$1$);TRUE;FALSE)
However it doesn't work because there is a formula in cell G3 so it is never empty ...

Can anybody point me in the right direction?

Thank you in advance.

[Pepe Le Mokko]

What do you mean by "date in F3 is older the date today " ?
The fact that there is a formula in a cell makes no difference
The IF is implicit in CF

Amai men aaarme !

[Stief1981]

Pepe Le Mokko

with that I mean for example
forecast date = 18/01/2019 and Actual date = 20/01/2019

international site and a reply from around the corner :-)

[JeteMc]

Try this: =AND(G3=0;F3>$B$1)
As Pepe states, the IF...TRUE;FALSE isn't necessary because the statement will evaluate to either true or false on its own.
Let us know if you have any questions.