Forum Discussion
Count using colours
I'm on excel 365, french. I'm looking for a way to count red colored cells, I used si.color but the error message appears. even the formula for identifying the color does not work.
If the cells have been colored manually, you need a custom VBA function. See for example Color Functions in Excel
If the cells are colored by conditional formatting, you can use COUNTIF or COUNTIFS (NB.SI or NB.SI.ENS in French) with the same conditions as used in the conditional formatting rule.