Aug 17 2021 02:31 PM
I am trying to highlight a date red if it has passed by ten days but only if the previous cell is blank I have tried this formula below but it is not working
=IF(AND(AZ5<=TODAY();AZ5="");1;0)
cell AZ5 contains the date and AY5 is the blank cell, assistance would be appreciated. Thankyou
Aug 17 2021 03:01 PM
SolutionAug 19 2021 01:09 AM
Aug 17 2021 03:01 PM
SolutionIt should be
=AND(AZ5<=TODAY()-10;AY5="")
(The IF is not really necessary)