Count using colours

Occasional Visitor

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.

1 Reply


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.