Hi Folks,

I have 2 columns:
F= date Opened
G= Date Closed

I have to check whether (date opened + 2) is greater than today's date and (date closed) is INITIAL. If YES, then I have to color the whole row RED.

I tried the following formula but it doesn't give me the expected result.
=IF((F2+2)<=today()&G3="","YES","NO")
And then apply conditional formatting on G3 to color the row RED.

Can anyone please tell me where I am going wrong???

Thanks in advance for your help