G
Guest
I WANT TO COUNT ALL THE ITEMS IN RED COLOR. HOW DO I DO IT
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
G
Gord Dibben
If you have Excel 2003(don't know about 2007)
You could try this alternate method which doesn't use VBA or any add-ins.
In 2003 you can specify the Format color to look for under
Edit>Find>Options>Format>Format.
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 Wed, 24 Oct 2007 06:10:04 -0700, Eirohl Seyer <Eirohl
You could try this alternate method which doesn't use VBA or any add-ins.
In 2003 you can specify the Format color to look for under
Edit>Find>Options>Format>Format.
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 Wed, 24 Oct 2007 06:10:04 -0700, Eirohl Seyer <Eirohl
G
Guest
Very neat Gord. Thanks for the tip!
Gord Dibben said:If you have Excel 2003(don't know about 2007)
You could try this alternate method which doesn't use VBA or any add-ins.
In 2003 you can specify the Format color to look for under
Edit>Find>Options>Format>Format.
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 Wed, 24 Oct 2007 06:10:04 -0700, Eirohl Seyer <Eirohl
G
Gord Dibben
A quick trick I learned on one of the Excel groups.
Actually, SHIFT + End + Down Arrow is faster for selecting all in the dialog
box.
Gord
Actually, SHIFT + End + Down Arrow is faster for selecting all in the dialog
box.
Gord