Count non-colored cells

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.

>-----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.
>.
Sorry - the Subject Line should have been "Count colored cells"

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" <[email protected]> schrieb im Newsbeitrag
news:[email protected]...
>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.

look here
http://www.cpearson.com/excel/cfcolors.htm

--
Don Guillett
SalesAid Software
[email protected]
"Ken G" <[email protected]> wrote in message
news:[email protected]...
> 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.