Count if cell is highlighted

[Sherree Gorman]

I have Excel 2007 and I do not know how to count yellow highlighted cells
within a column. I saw a response to this question but it was for Excel 2003
and the answer included using VB. I do not know how to use VB. Is there an
easier way?

 

[T. Valko]

Is there an easier way?

Yes. Write a formula based on the logic of *why* the cells are shaded
yellow.

 

[Gord Dibben]

Why are the cells colored yellow?

If by Conditional Formatting, use the same criterion to count the cells.

If manually colored you have to use VBA or this method below.

For 2003 I would do an Edit>Find for the Format yellow and Find All.

Hit CTRL + a to select all in the "Found" dialog then on Status Bar select
"Count"


Gord Dibben MS Excel MVP