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

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


"Alan M" wrote in message
...
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

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

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Alan M" wrote in message
...
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