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.
Bookmarks