Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count all the text in red
I WANT TO COUNT ALL THE ITEMS IN RED COLOR. HOW DO I DO IT
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count all the text in red
see:
http://www.cpearson.com/excel/colors.htm -- Gary''s Student - gsnu200750 "Eirohl Seyer" wrote: I WANT TO COUNT ALL THE ITEMS IN RED COLOR. HOW DO I DO IT |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count all the text in red
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 EditFindOptionsFormatFormat. 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 wrote: I WANT TO COUNT ALL THE ITEMS IN RED COLOR. HOW DO I DO IT |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count all the text in red
Very neat Gord. Thanks for the tip!
"Gord Dibben" wrote: 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 EditFindOptionsFormatFormat. 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 wrote: I WANT TO COUNT ALL THE ITEMS IN RED COLOR. HOW DO I DO IT |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
count all the text in red
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 On Wed, 24 Oct 2007 12:08:01 -0700, diaare wrote: Very neat Gord. Thanks for the tip! "Gord Dibben" wrote: 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 EditFindOptionsFormatFormat. 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 wrote: I WANT TO COUNT ALL THE ITEMS IN RED COLOR. HOW DO I DO IT |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count single Text in cells with multiple text entries | Excel Discussion (Misc queries) | |||
how do i count text and display it as text plus the # times it hap | New Users to Excel | |||
how do I count the number of times text in column A matches text i | Excel Worksheet Functions | |||
Formula to count text and alert me if a text appears more than twi | Excel Discussion (Misc queries) | |||
Count Intervals of Filtered TEXT values in Column and Return Count across a Row | Excel Worksheet Functions |