Counting Cells With A Specific Color

[gaspard.jouandon]

Dear Receiver,

Can someone have a formula or can explain this one found
on http://www.cpearson.com/excel/colors.htm
=COUNTBYCOLOR(A1:A10,3,FALSE)
to counting cells with A specific color.

Thanks in advance - Gaspard

 

[John Wilson]

gaspard,

That formula is dependent on a custom function that Chip
created so that you could have a formula to count either
text or background colors.

You have to copy and paste Chip's function into a regular
VBA module for the formula to be able to work.

In the formula:
=COUNTBYCOLOR(A1:A10,3,FALSE)
It will return a count of the number of cells within
A1:A10 that have a color index of 3 (Red)
If you were to change the False to True, it would look at
the text color as opposed to the background color.

John