CountIf function query

[Guest]

Hi,

Is it possible to use the CountIF function to return the number of cells in
a specific range which have a particular interior colour regardless of the
value content of the cell?

If so what information should be used in the 'Criteria' section of the
function wizard?

I have tried putting in .Interior.ClourIndex = 6 but this does not do
anything

 

[Chip Pearson]

It is not possible without a custom function. See
www.cpearson.com/excel/colors.htm for details and example code.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

 

[Bob Phillips]

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)