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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count the numbers in a Word document? 0
Consolidation Table from Different Excel Tabs with Different Format 1
Count of Font Format 1
Need to count no. of rows where cell in column A = "value1" AND cellin column B (same row) = "value2 2
Need to count cells in Column1 where each cell's row also hasspecified value in Column2 2
Count Interior Colour 7
Pivot Table Counting Text Issue 0
Section and Page numbering 0

Top