Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Formula to count the cells in a range that have a fill color. | Excel Discussion (Misc queries) | |||
Count non-colored cells | Excel Discussion (Misc queries) | |||
Count number of shaded cells | Excel Discussion (Misc queries) | |||
Protected cells -automatically format to a different color | Excel Discussion (Misc queries) |