Count number of cells that are highlighted
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
|