Jul 16 2020 09:39 AM
Hi - I need some help with conditional formatting in Excel. I'm trying to say "If the date in a cell (D10) is in the past & the cell below (D11) is blank THEN turn red".
I'm typing this "=AND (d10<TODAY() , ISBLANK (d11))" but having no joy.
Can anyone correct where I'm going wrong ?
Thanks
Jul 16 2020 09:43 AM
Hello @owenj,
Your formula appears correct. Perhaps there is a typo? This is precisely what I used:
=AND(D10<TODAY(), ISBLANK(D11))
Jul 16 2020 09:47 AM