Hi Victor,

Am Fri, 15 Jan 2016 20:53:52 -0000 schrieb Victor Delta:

Does anyone please know if there is a way to count the cells in this
range which have a particular colour - say yellow?

try it with SUMPRODUCT and use the condition for the yellow color in
that formula.


Regards
Claus B.
--
Vista Ultimate / Windows7
Office 2007 Ultimate / 2010 Professional