Count by format

J

Josh

I want to count all the cells in a column that are filled in red. How do I
type the formula?

Thanks a lot in advanced!
 
G

Gord Dibben

How did they get to be red?

If by conditional formatting, count the values that turned them red.

If manually colored here is a non-programmatic method.

CTRL + a to select all cells.

Edit>Find>Format>Format>Pattern...........click on red and "Find All"

In the "found" dialog box hit CTRL + a to select all in that box.

Now right-click in status bar and select "count" from the options.


Gord Dibben MS Excel MVP
 
J

Josh

That was really helpful.

Do you happen to know the translation of: COLORINDEXOFRANGE into spanish.

Thanks a lot
 
Top