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

--
Regards,
Zack Barresse, aka firefytr, (GT = TFS FF Zack)




"reno" wrote in message
...
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