Take a look at http://www.xldynamic.com/source/xld.ColourCounter.html, and
use a formula like

=SUMPRODUCT(--(ColorIndex(A1:A100)=3),--(A1:A1000="G"))

--
HTH

Bob Phillips

"Peter" wrote in message
...
Hi,

I know I can count the number of appearances of, say, the letter G in
a particular row or column using the COUNTIF function.

But can anyone please advise if it is possible to count, say, the
number of times the letter G appears in a row or column, but only in
cells that have a coloured background?


--
Cheers

Peter

Please remove the invalid to reply