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