Counting color filled cells? For an Idiot.

[jojones88]

I need help. I have compiled a work sheet that contains master id
numbers for gage parts for a company. Every once and a while a part
will get rusted or scratched and this must be recorded. So I created
this worksheet that has the part size in the A column (consists of 900
different parts) and the serial of each gage of a particular part size
in the corresponding row.
So this has created a huge sheet of data. My boss takes a look at
the key that I used so that people know what all the colors mean.
Green means lost, Red means scratched, Pink means out of tolerance. He
told me that he would like to know how many parts that have been lost.
Each of these gages costs about $60 so he would like to see how much
money has been thrown away because of irresponsible workers.
The thing is that I have know idea how to enter a formula in and
I am not aware of any site that can explain this to me easily enough
for me to understand. Any help would greatly be appreciated.

-jojones88

 

[Guest]

see:

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

 

[jojones88]

Is there something a little more dumbed down so that I can understand.
I have very little excel experience.

Thank You

 

[Gord Dibben]

In 2003 you can specify the Format color to look for under
Edit>Find>Options>Format>Format.

You could try this alternate method which doesn't use VBA.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted. Hold SHIFT key and
scroll down to bottom of dialog box and select last cell.

The selected cells can then be counted by right-click on Status Bar and "Count".

Then write it down for the boss.

Do for each color.


Gord Dibben MS Excel MVP

 

[jojones88]

THANK YOU!

You guys have been a huge help.
Thank you very very much!

 

[Dallman Ross]

You could try this alternate method which doesn't use VBA.

Select the color from the Patterns dialog and Find All.

In the found dialog box the first cell will be highlighted. Hold SHIFT key and
scroll down to bottom of dialog box and select last cell.

The selected cells can then be counted by right-click on Status Bar and "Count".

Heh. That is slick, Gord! I like that. Thanks for the idea.

=dman=

 

[Gord Dibben]

Gleaned the tip from a post by someone(not a regular) a few months ago.

Quick and easy if you don't need the results in a cell.


Gord