i have looked around the answers for this but cant seem to get any to work. i
am looking for a formula to look in A1:A160 and count the cells if they are
blue or Red the text in them is irrelivant

Thanks in advance

see:

http://www.cpearson.com/excel/colors.htm


--
Gary''s Student - gsnu200770


"Arnie" wrote:

i have looked around the answers for this but cant seem to get any to work. i
am looking for a formula to look in A1:A160 and count the cells if they are
blue or Red the text in them is irrelivant

Thanks in advance

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Arnie" wrote in message
...
i have looked around the answers for this but cant seem to get any to work.
i
am looking for a formula to look in A1:A160 and count the cells if they
are
blue or Red the text in them is irrelivant

Thanks in advance

Bob i tried both of those and i was getting #Name when i evaluated it the "
ColorIndex" was the culprit i then defined ColorIndex and SumProduct and now
i get #Ref any ideas?

"Bob Phillips" wrote:

See http://www.xldynamic.com/source/xld.ColourCounter.html for a working
solution

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Arnie" wrote in message
...
i have looked around the answers for this but cant seem to get any to work.
i
am looking for a formula to look in A1:A160 and count the cells if they
are
blue or Red the text in them is irrelivant

Thanks in advance