Something other than a white background and a black font. It is highlighted
with a conditional format. Let's say I have selected cells B1:B10. I want
to know how many are highlighted.

Thanks

"macropod" wrote:

Hi Barb

How do you determine which cells have background highlighting? Is it all
cells on a worksheet, a named range or a particular area?

Is the background highlighting dynamic (eg the result of conditional
formatting)?

What colour(s) do you use for the background highlighting?

Cheers

--
macropod
[MVP - Microsoft Word]


"Barb Reinhardt" wrote in message
...
I'd like to have a formula that would allow me to enter a range of values
and
it would tell me how many cells have background highlighting (something
along
the lines of countif). Can someone assist?

Thanks,
Barb Reinhardt