View Single Post
  #3   Report Post  
Frank Kabel
 
Posts: n/a
Default

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.