Forum Discussion
Solved
Count number of cells in each row assigned different colors through Conditional formatting
Hello community! I'm new here and have a question on how to count number of cells in each row that have been assigned different colors through Conditional formatting in Excel 365. I have done...
Refer to the conditions instead of to the colors:
In H3: =COUNTIFS($D3:$F3,">"&$B3,$D3:$F3,"<"&$C3)
In I3: =COUNTIF($D3:$F3,$B3)+COUNTIF($D3:$F3,$C3)
In J3: =COUNTIFS($D3:$F3,"<"&$B3,$D3:$F3,"<>")+COUNTIFS($D3:$F3,">"&$C3,$D3:$F3,"<>")
Fill down.
HansVogelaar Great way to think about it - referencing the conditions instead of the actual colors - and it works beautifully! I would never have come up with those countifs formulas; thank you so much!