Count number of coloured cells

**nancyching1711** · 12-26-2012, 01:23 PM

Hi

Is there a formula to count the number of coloured cells in a worksheet.

Thanks and Regards

Nancy

**Fotis1991** · 12-26-2012, 01:32 PM

One way is this.

**nancyching1711** · 12-26-2012, 01:44 PM

Hi Foltis

You are great.

Thanks

Nancy

**Leith Ross** · 12-26-2012, 01:49 PM

Hello Nancy,

There are a few things to consider when counting colored cells.

VBA does not generate an event when the color of the cell is changed.
VBA does not recognize color changes from Conditional Formatting.
Conditionally Formatted cells can be counted if cells have a value associated with the color.

Re: Count number of coloured cells