Forum Discussion
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
Try Hecatonchire solution. I over complicated mine.
- I deleted my original formatting rule and it's working properly. Thank you so very much for your help! Made my day! 😊
