Hi
though this is possible it's a little bit complicated. Why not use the same
criteria in a formula as you have don in the conditional format dialog
()e.g. use COUNTIF)
--
Regards
Frank Kabel
Frankfurt, Germany
"Ken G" schrieb im Newsbeitrag
...
I have a sheet that highlights cells in a range if any of
those cells contain values from a manually entered range
using the "countif" function and conditional formatting.
How do I count the number of cells which have been
conditionally formatted - with a fill color.
|