Vic,

This has been answered many different ways in this discussion group. If you
search for the expression Count Shaded Cells you can find many posts on this.
There is no built in function in Excel for this. you can get into user
defined functions and VBA and it can get pretty hairy.

This one sums up the situation pretty well.

http://www.microsoft.com/office/comm...1-31a05aa735b9

If there is a reason for the shading use a function like COUNTIF based on
the reasoning.

--
If this helps, please remember to click yes.


"Vic" wrote:

What is the formula to count Red highlighted cells in the range F2 thru S412?
I also need formulas to count separately Yellow and Sky Blue cells in the
same range.
Thank you.