I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack

Try Chip Pearson's site. This page has examples of how to count colors.
http://www.cpearson.com/excel/colors.htm

"Jack_Feeman" wrote:

I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack

I certainly will, thanks Chip for such a quick response.
Jack

"JLatham" wrote:

Try Chip Pearson's site. This page has examples of how to count colors.
http://www.cpearson.com/excel/colors.htm

"Jack_Feeman" wrote:

I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack

I'm not Chip - but Chip's site already had the answer, so rather than
reinvent a wheel, I simply pointed you to his site <g.

"Jack_Feeman" wrote:

I certainly will, thanks Chip for such a quick response.
Jack

"JLatham" wrote:

Try Chip Pearson's site. This page has examples of how to count colors.
http://www.cpearson.com/excel/colors.htm

"Jack_Feeman" wrote:

I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack

Oops sorry about that. Guess my eyes saw "Chip" and my brain went along for
the ride. Thanks to both of you. Jack

"JLatham" wrote:

I'm not Chip - but Chip's site already had the answer, so rather than
reinvent a wheel, I simply pointed you to his site <g.

"Jack_Feeman" wrote:

I certainly will, thanks Chip for such a quick response.
Jack

"JLatham" wrote:

Try Chip Pearson's site. This page has examples of how to count colors.
http://www.cpearson.com/excel/colors.htm

"Jack_Feeman" wrote:

I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack

In 2003 you can specify the Format color to look for under
EditFindOptionsFormatFormat.

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".


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 07:24:02 -0700, Jack_Feeman
wrote:

I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack

Thanks for the additional info. I will test it out.
Jack

"Gord Dibben" wrote:

In 2003 you can specify the Format color to look for under
EditFindOptionsFormatFormat.

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".


Gord Dibben MS Excel MVP

On Thu, 19 Jul 2007 07:24:02 -0700, Jack_Feeman
wrote:

I didn't see any mention of this in my search so maybe it can't be done. I
have a color coded spreadsheet and want to count the number of instances for
each color. Any help is appreciated. Thanks Jack