Conditional formatting using 2 conditions

%3CLINGO-SUB%20id%3D%22lingo-sub-1527021%22%20slang%3D%22en-US%22%3EConditional%20formatting%20using%202%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527021%22%20slang%3D%22en-US%22%3E%3CP%20class%3D%22paragraph-254%22%3EHi%20-%20I%20need%20some%20help%20with%20conditional%20formatting%20in%20Excel.%20I'm%20trying%20to%20say%20%22If%20the%20date%20in%20a%20cell%20(D10)%20is%20in%20the%20past%20%26amp%3B%20the%20cell%20below%20(D11)%20is%20blank%20THEN%20turn%20red%22.%3C%2FP%3E%3CP%20class%3D%22paragraph-254%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22paragraph-254%22%3EI'm%20typing%20this%20%22%3DAND%20(d10%3CTODAY%3E%3C%2FTODAY%3E%3C%2FP%3E%3CP%20class%3D%22paragraph-254%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22paragraph-254%22%3ECan%20anyone%20correct%20where%20I'm%20going%20wrong%20%3F%3C%2FP%3E%3CP%20class%3D%22paragraph-254%22%3E%26nbsp%3B%3C%2FP%3E%3CP%20class%3D%22paragraph-254%22%3EThanks%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1527021%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527040%22%20slang%3D%22en-US%22%3ERe%3A%20Conditional%20formatting%20using%202%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527040%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730989%22%20target%3D%22_blank%22%3E%40owenj%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYour%20formula%20appears%20correct.%20Perhaps%20there%20is%20a%20typo%3F%20This%20is%20precisely%20what%20I%20used%3A%3C%2FP%3E%3CPRE%3E%3DAND(D10%26lt%3BTODAY()%2C%20ISBLANK(D11))%3C%2FPRE%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527056%22%20slang%3D%22en-US%22%3ERE%3A%20Conditional%20formatting%20using%202%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527056%22%20slang%3D%22en-US%22%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F360420%22%20target%3D%22_blank%22%3E%40PReagan%3C%2FA%3E%20-%20it%20now%20works%20so%20yeah%20-%20I%20guess%20there%20was%20something%20weird%20there.%20Just%20deleted%20everything%20and%20re-typed%20it%20in.%20Thanks%20for%20the%20quick%20reply%20!%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1527058%22%20slang%3D%22en-US%22%3ERE%3A%20Conditional%20formatting%20using%202%20conditions%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1527058%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F730989%22%20target%3D%22_blank%22%3E%40owenj%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EMy%20pleasure!%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

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

3 Replies

Hello @owenj,

 

Your formula appears correct. Perhaps there is a typo? This is precisely what I used:

=AND(D10<TODAY(), ISBLANK(D11))

 

@PReagan - it now works so yeah - I guess there was something weird there. Just deleted everything and re-typed it in. Thanks for the quick reply !

@owenj 

 

My pleasure!