SOLVED

Conditional formatting when a date is passed only if previous cell is blank

Copper Contributor

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

2 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Lizns 

It should be

=AND(AZ5<=TODAY()-10;AY5="")

(The IF is not really necessary)

1 best response

Accepted Solutions
best response confirmed by allyreckerman (Microsoft)
Solution

@Lizns 

It should be

=AND(AZ5<=TODAY()-10;AY5="")

(The IF is not really necessary)

View solution in original post