Counting Formatted cells

[Art MacNeil]

Hi all,

Is there a way to count cells which have been formatted? If so, can I
count Blue cells, and then Red cells, then Green cells separately? Finally,
can I count cells which have been conditionally formatted?


For example:

For cells A5 to L8

A5 is Blue. So is D5 and L5. That would be 3 of 12 cells that are
formatted.

Row 6 has no formatted cells.

Row 7 has no formatted cells.

B8 is Red, C8 is Green and G8 is Blue. Again, 3 of 12 cells are formatted
but each cell has different formatting.

Can these cells be counted using a formula?


Finally, assume the same circumstances but this time each cell is coloured
due to conditional formatting.

Can those cells be counted using a formula?



Thanks,

Art.

 

[Bob Phillips]

SEe http://www.xldynamic.com/source/xld.ColourCounter.html but note the
constraints.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Art MacNeil]

Thanks for the info.

SEe http://www.xldynamic.com/source/xld.ColourCounter.html but note the
constraints.

--

HTH

RP
(remove nothere from the email address if mailing direct)