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