Count Colors; Conditional Formatting Used

  • Thread starter Thread starter ryguy7272
  • Start date Start date
R

ryguy7272

Does anyone know how to count colors, if colors were applied with CF?
I went to Chip's site (one of my favorites):
http://www.cpearson.com/excel/CFColors.htm

I tried to use this function:
=CountOfCF(A1:A10,1)

Couldn't get it to work... All I get is #VALUE!
What am I doing wrong?
 
Problem resolved! Just fiddled with it some more... Well, mostly
resolved...counted colors in individual cells and then used Countif to count
THOSE cells. I thought the function would have counted all CF-reds, for
instance, in just one cell...ended up using helper columns/rows.


Thanks CP!!
Ryan---
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

counting CF cells 2
Count cells with Conditional Formatting 10
Chip Pearson UDF returns #VALUE! error please help, just cannotfigure out why? 4
"Sum only the colored cells" custom function 5
Excel VBA - counting cells by colors and names to it in two different rows. 0
Counting Colors of Cells set by Conditional Formatting 2
Considering cells colored via conditional formatting 1
Conditional Formatted Colored Cells 1

Back
Top