[quote=ruthhicks999] Is there anyway that I can do the countif so that it will count all of the cells with a specific background colour.
QUOTE]

I really like the similar questions feature have followed a previous enquiry which was simialar and found my answer. Thank you.