Count cells with the red color
 

Hi,
I'd like to be able to count all the cells that are red (I made them
red, not conditional formatting) in my spreadsheet.

How can I achive that?

Thanks in advance! :)

// Coolcat


--
Collcat
------------------------------------------------------------------------
Collcat's Profile: http://www.excelforum.com/member.php...o&userid=15598
View this thread: http://www.excelforum.com/showthread...hreadid=272865

Hi
see:
http://www.xldynamic.com/source/xld.ColourCounter.html
and
http://www.cpearson.com/excel/colors.htm

--
Regards
Frank Kabel
Frankfurt, Germany


Collcat wrote:
Hi,
I'd like to be able to count all the cells that are red (I made them
red, not conditional formatting) in my spreadsheet.

How can I achive that?

Thanks in advance! :)

// Coolcat