Hi Barb,

You can do this with formulae in cells using the same logic as your
conditional formatting formulae.

Cheers

--
macropod
[MVP - Microsoft Word]


"Barb Reinhardt" wrote in message
...
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