Count if cell is highlighted
 

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?

Count if cell is highlighted
 

Is there an easier way?

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

--
Biff
Microsoft Excel MVP


"Sherree Gorman" wrote in message
...
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?

Count if cell is highlighted
 

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 EditFind 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

On Fri, 26 Dec 2008 19:14:01 -0800, Sherree Gorman
wrote:

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?