Forum Discussion
Solved
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...
Add this conditional formatting in second position
=COUNTIFS($D$5:$D$9;$D5;$AB$5:$AB$9;"Not Loaded")
Adjust value 9
Add this conditional formatting in second position
=COUNTIFS($D$5:$D$9;$D5;$AB$5:$AB$9;"Not Loaded")
Adjust value 9
I could not get this formula to work in conditional formatting - but I added a column with the COUNTIFS formula to return a value. Then, I added a new conditional formatting rule so if any value in the COUNTIFS column AD is greater than 0 - highlight it. Thank you so very much! I spent a ridiculous amount of time trying to figure this out!
