ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Count cells with the red color (https://www.excelbanter.com/excel-worksheet-functions/5123-count-cells-red-color.html)

Collcat October 27th 04 04:54 PM

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


Frank Kabel October 27th 04 05:26 PM

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



All times are GMT +1. The time now is 10:40 PM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
ExcelBanter.com