This should give you what you need

http://www.xldynamic.com/source/xld.ColourCounter.html

--
__________________________________
HTH

Bob

"Ksenija" wrote in message
...
Hi,

I have cells with different colours. I want to go through a column and
look
for the max.value of red cells, the average of red cells and the median of
red cells. S

So I want to ignore cells with other colours and just use cells with a
specific colour.

Can somebody help me with this? I'm very new at this, have tried for a
while
now, but it's not working..