I am trying to count the number of cells in a range that have
..Font.ColorIndex=6
AND
..Interior.ColorIndex=[1, 2, 3 or 4]

I've tried using the UDFs from http://www.cpearson.com/excel/colors.htm but
I'm having no luck in combining these with a formula.

Does anyone know how to do this?

Kind regards,
Samuel Harmer