how do I count the number of gray-shaded cells within a range?

[Y]

I want to use the format of the cell (font color, shading color, etc.) as a
criterium in a countif formula. How do I do it? what's the syntax for that.
thanks.

[Niek Otten]

http://www.cpearson.com/excel/colors.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Y" <Y@discussions.microsoft.com> wrote in message news:44D80827-B76F-4357-927C-B924F260E5EA@microsoft.com...
|I want to use the format of the cell (font color, shading color, etc.) as a
| criterium in a countif formula. How do I do it? what's the syntax for that.
| thanks.

[Gary]

I tried what is mentioned on this site but its giving me a #NAME error.

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:O2tVE4FvGHA.4756@TK2MSFTNGP04.phx.gbl...
> http://www.cpearson.com/excel/colors.htm
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Y" <Y@discussions.microsoft.com> wrote in message
> news:44D80827-B76F-4357-927C-B924F260E5EA@microsoft.com...
> |I want to use the format of the cell (font color, shading color, etc.) as
> a
> | criterium in a countif formula. How do I do it? what's the syntax for
> that.
> | thanks.
>
>

[Niek Otten]

Try this one:

http://xldynamic.com/source/xld.ColourCounter.html

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gary" <gaurav_ss@hotmail.com> wrote in message news:%23FXRHOGvGHA.4756@TK2MSFTNGP02.phx.gbl...
|I tried what is mentioned on this site but its giving me a #NAME error.
|
| "Niek Otten" <nicolaus@xs4all.nl> wrote in message
| news:O2tVE4FvGHA.4756@TK2MSFTNGP04.phx.gbl...
| > http://www.cpearson.com/excel/colors.htm
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > "Y" <Y@discussions.microsoft.com> wrote in message
| > news:44D80827-B76F-4357-927C-B924F260E5EA@microsoft.com...
| > |I want to use the format of the cell (font color, shading color, etc.) as
| > a
| > | criterium in a countif formula. How do I do it? what's the syntax for
| > that.
| > | thanks.
| >
| >
|
|

[Bob Phillips]

and don't forget to copy the supplied UDF into your workbook!

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Niek Otten" <nicolaus@xs4all.nl> wrote in message
news:%23XQuaYGvGHA.4688@TK2MSFTNGP06.phx.gbl...
> Try this one:
>
> http://xldynamic.com/source/xld.ColourCounter.html
>
> --
> Kind regards,
>
> Niek Otten
> Microsoft MVP - Excel
>
> "Gary" <gaurav_ss@hotmail.com> wrote in message
news:%23FXRHOGvGHA.4756@TK2MSFTNGP02.phx.gbl...
> |I tried what is mentioned on this site but its giving me a #NAME error.
> |
> | "Niek Otten" <nicolaus@xs4all.nl> wrote in message
> | news:O2tVE4FvGHA.4756@TK2MSFTNGP04.phx.gbl...
> | > http://www.cpearson.com/excel/colors.htm
> | >
> | > --
> | > Kind regards,
> | >
> | > Niek Otten
> | > Microsoft MVP - Excel
> | >
> | > "Y" <Y@discussions.microsoft.com> wrote in message
> | > news:44D80827-B76F-4357-927C-B924F260E5EA@microsoft.com...
> | > |I want to use the format of the cell (font color, shading color,
etc.) as
> | > a
> | > | criterium in a countif formula. How do I do it? what's the syntax
for
> | > that.
> | > | thanks.
> | >
> | >
> |
> |
>
>