Re: count all the text in red

Tech-Archive recommends: Speed Up your PC by fixing your registry

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 <diaare@xxxxxxxxxxxxxxxxxxxxxxxxx>
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
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
Seyer@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote:

I WANT TO COUNT ALL THE ITEMS IN RED COLOR. HOW DO I DO IT



.

Relevant Pages

  • Re: How fill column quickly
    ... I do shift return. ... cell is selected, not all the cells in-between which is needed. ... selecting A10:A200 ... type in the A200 cell reference in the "Name field" and Press the Return key ...
    (microsoft.public.mac.office.excel)
  • Re: Bargello finds today
    ... Completely guessing here, because I don't know what program you're ... but you might be able to shift a whole column up one cell by ... selecting something like "shift cells up". ...
    (rec.crafts.textiles.quilting)
  • Re: Using Ctrl key and Shift key
    ... selecting multiple files but when I hold the shift key and select a 2nd file ... > Mike has explained the mechanics of using Shift and Ctrl to select files. ...
    (microsoft.public.windowsxp.newusers)
  • Re: Lines in header
    ... Try selecting one line, then hold Shift while you click the others, then ... at the right-hand edge of my pages of a Tender document. ... Has anyone idea of the reason and how I can put this right, ...
    (microsoft.public.word.newusers)
  • Re: Using "Select multiple files or folders"
    ... You have the "SHIFT" key part right for selecting all files inbetween ... My last OS did it this way, but Vista does not. ... How do I easily select multiple files? ...
    (microsoft.public.windows.vista.file_management)