Count non-colored cells

K

Ken G

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.
 
K

Ken G

-----Original Message-----
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.
.
Click to expand...
Sorry - the Subject Line should have been "Count colored cells"
 
F

Frank Kabel

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)
 
Top