In Excel, how do I count cells with a particular format (e.g. colo

V

voyagerff

I inherited a large spreadsheet with certain rows colored red. I want to be
able to count the red rows (or cells).
Is there some function that can test for a cell's formats? Or is there some
technique using macros?
Thanks in advance.
 
N

Niek Otten

Look here:

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I inherited a large spreadsheet with certain rows colored red. I want to be
| able to count the red rows (or cells).
| Is there some function that can test for a cell's formats? Or is there some
| technique using macros?
| Thanks in advance.
 
G

Gord Dibben

To count colored red cells.................

Select the sheet's used range.

Edit>Find>Format>Format>Patterns

Pick the red color and OK

Find All

In the "found" dialog hit SHIFT + End

Right-click on the Statuys Bar and "count"


Gord Dibben MS Excel MVP
 

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

Counting Cells by Format 2
How to Color a Cell Based on a Range of Cells with Colors 1
How can I count the number of cells with a particular color/shade 2
count how many rows a word appears in 1
Conditional Formatting for multiple cells 2
How to filter rows data based on background color of individual cells 1
Count cells in range w/specific background color? 3
Conditional Formatting ignoring cells with a format already 2

Top