Counting colors

R

reno

have a 50 row listing of stores. each month(columns) the top seller has it
sales highlighted in red. want a countif is red in the row
thanks
 
Z

Zack Barresse

Hi there,

Take a look at Chip Pearson's work here ...

http://www.cpearson.com/excel/colors.htm

Note, this does not handle Conditional Formatting. If this is what is
returning your color, you'll need to seek an alternate method(s). For an
explanation on Conditional Formatting, Chip also has a page for that ...

http://www.cpearson.com/excel/cformatting.htm

To use CF colors as you would a standard colorindex of a cell, you can make
use of a routine, something like the one found here ...

http://vbaexpress.com/kb/getarticle.php?kb_id=190

HTH
 
Top