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

Y

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

Niek Otten

Try this one:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|I tried what is mentioned on this site but its giving me a #NAME error.
|
| | > http://www.cpearson.com/excel/colors.htm
| >
| > --
| > Kind regards,
| >
| > Niek Otten
| > Microsoft MVP - Excel
| >
| > | > |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.
| >
| >
|
|
 
B

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I convert shading to highlighting for specific colors 8
Select text of a particular shading color (VBA macro) 5
Need help modifying code 0
Count Number of Unique Cells That Don't Have Certain Characters 0
macro to disallow shading in certain columns 2
SUMIF based on cell shading 1
Conditional Formatting Formula 2
Shading Rows With IF Statements? 5

Top