Counting by Fill Color

Mar 7th, 2002, 05:51 AM

Help! I need a formula that will enable my spread sheet to count the different colors of cells. For example: A column from B2 to B10 has three different shades of color(red, yellow, and green), I would like cell B12 to tell me how many "reds" there are, cell B13 shows how many "yellows" and B14 shows the "greens". Any ideas? I've tried several formulas based on the color index number, but to no avail. Thanks.

Steve Hartman · Mar 7th, 2002, 06:56 AM

Use the Search function of the board. This question has been addressed several times recently.

nisht · Mar 7th, 2002, 07:20 AM

Friend,

goto site..www.pexcel.com

here download file...

countingcolorindex.

this a small utility made by me .. and it is just for free...

nishith

Mar 7th, 2002, 06:56 AM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	Use the Search function of the board. This question has been addressed several times recently. __________________ Veni, Vidi, Velcro - I came, I saw, I stuck around Taxation WITH representation ain't so hot either

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

Mar 7th, 2002, 05:51 AM	#1
Guest Posts: n/a	Help! I need a formula that will enable my spread sheet to count the different colors of cells. For example: A column from B2 to B10 has three different shades of color(red, yellow, and green), I would like cell B12 to tell me how many "reds" there are, cell B13 shows how many "yellows" and B14 shows the "greens". Any ideas? I've tried several formulas based on the color index number, but to no avail. Thanks.

Mar 7th, 2002, 07:20 AM	#3
nisht Board Regular Join Date: Feb 2002 Location: Ahmedabad Gujarat Posts: 303	Friend, goto site..www.pexcel.com here download file... countingcolorindex. this a small utility made by me .. and it is just for free... nishith