how to count cells with specific format (background color)?

Blackheartedowl · February 8th, 2006, 07:40 AM posted to microsoft.public.excel.misc

i need to count cells from a range that have a specific background color.
what formula should i used and how.
do i use, countif(range, criteria???) how should i write the criteria.
or is there any way to do this. thanx

Norman Jones · February 8th, 2006, 08:21 AM posted to microsoft.public.excel.misc

Hi BlackHeartedOwl,

See xlDynamic's ColourCounter page at:

http://www.xldynamic.com/source/xld.ColourCounter.html

See Chip Pearson's 'Functions For Working With Cell Colors' page at:

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

---
Regards,
Norman

"Blackheartedowl" wrote in
message ...
i need to count cells from a range that have a specific background color.
what formula should i used and how.
do i use, countif(range, criteria???) how should i write the criteria.
or is there any way to do this. thanx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How do you count cells with background color yellow?	Stephanie D	General Discussion	6	October 18th, 2005 04:34 AM
how to count number of cells in a color ?	Francisco	General Discussion	4	September 25th, 2005 01:09 PM
How do I get colour separated printouts red and black?	Karen	Publisher	2	November 27th, 2004 11:14 PM
How to sort cells by background color?	Stanley F.	General Discussion	2	August 30th, 2004 06:33 PM
5 conditions to format background color??	Dan Johnston	Worksheet Functions	2	September 23rd, 2003 08:29 PM