Forum Discussion

ShainaDay88's avatar
ShainaDay88
Copper Contributor
Mar 15, 2023

Excel - Nested formulas in conditional formatting - Nightmare!

I can not figure out how to conditionally format other rows that match the value highlighted in column D. Column D is formatted by Column AB containing "Not Loaded" - I need to highlight the other ro...
Macros and VBA
  • Hecatonchire's avatar
    Hecatonchire
    Mar 16, 2023

    Add this conditional formatting in second position

     

    =COUNTIFS($D$5:$D$9;$D5;$AB$5:$AB$9;"Not Loaded")

     

    Adjust value 9

     

     

    ShainaDay88 

mtarler's avatar
mtarler
Silver Contributor
Mar 16, 2023
If you post a sample sheet to work with we can better create a formula to help but I think you could use something like:
=ISNUMBER(XMATCH(D5, FILTER(D5:D10000, AB5:AB10000="Not Loaded","")))
  • ShainaDay88's avatar
    ShainaDay88
    Copper Contributor
    Mar 16, 2023

    Partial Comm Sample to Post

    Let me know if this link doesn’t work. I’m on my phone and I don’t see anywhere to upload an attachment of the partial spreadsheet. I will check again when I get home to see if I can add an attachment. Can you see the screenshot? Thank you for attempting it!

Resources