Count the number of times a cell in a column is shaded green

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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>.
 
Oops sorry about that. Guess my eyes saw "Chip" and my brain went along for
the ride. Thanks to both of you. Jack
 
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".


Gord Dibben MS Excel MVP
 
Back
Top