Subject: Excel help

Can anybody help me with my last question in this thread?

Thanks.

check it..

Have done, and replied ;o)

hi, i wanted to ask, does exist any formula, which would count boxes coloured in one colour? I mean, this formula should count boxes coloured eg red and connect these boxes with number eg 10, green ones to 5 and in result will add all 'scores' and show me a final result.

I don't think you can do any searches or formulas for colours i'm afraid, only with data in the boxes.

Obviously you can colour all cells containing the number 5 red quite easily.