SOLVED

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

%3CLINGO-SUB%20id%3D%22lingo-sub-2657922%22%20slang%3D%22en-US%22%3EConditional%20formatting%20when%20a%20date%20is%20passed%20only%20if%20previous%20cell%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2657922%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20trying%20to%20highlight%20a%20date%20red%20if%20it%20has%20passed%20by%20ten%20days%20but%20only%20if%20the%20previous%20cell%20is%20blank%20I%20have%20tried%20this%20formula%20below%20but%20it%20is%20not%20working%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-excel-formula%22%3E%3CCODE%3E%3DIF(AND(AZ5%26lt%3B%3DTODAY()%3BAZ5%3D%22%22)%3B1%3B0)%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ecell%20AZ5%20contains%20the%20date%20and%20AY5%20is%20the%20blank%20cell%2C%20assistance%20would%20be%20appreciated.%26nbsp%3B%20Thankyou%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2657922%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2658015%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20when%20a%20date%20is%20passed%20only%20if%20previous%20cell%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2658015%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1130728%22%20target%3D%22_blank%22%3E%40Lizns%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIt%20should%20be%3C%2FP%3E%0A%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DAND(AZ5%26lt%3B%3DTODAY()-10%3BAY5%3D%22%22)%3C%2FCODE%3E%3C%2FPRE%3E%0A%3CP%3E(The%20IF%20is%20not%20really%20necessary)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2663893%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20when%20a%20date%20is%20passed%20only%20if%20previous%20cell%20is%20blank%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2663893%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%2C%20much%20appreciated%3C%2FP%3E%3C%2FLINGO-BODY%3E
New 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)