search a series of rows for a specific formating

[Guest]

I have a series of cells containing some numbers and the background in some
of theese cells is red. Can I count theese red cells and have the result in
another cell?

 

[Dave Peterson]

There's nothing built into excel that allows you to do this. But Chip Pearson
has a routine that will help:

http://www.cpearson.com/excel/colors.htm
Look for: Counting Cells With A Specific Color

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

 

[Biff]

Hi!

Why is the background in some of the cells red?

It may be easier to count the cells based on the logic that is used to color
the cells. (and it's a lot more reliable than counting colors)

Biff