You need to supply the function code, and the criteria you refer to....also
what version of xl are you using, color management is far easier in xl2007

--

Regards,
Nigel




"ciprian" wrote in message
...
Hi,

I try to color the cell in witch i run the function based on the results
from others cells below it.

the problem: on A1 i have the function =color_me( A2:A10 )
in A2 throw A10 i have different texts wit different color, i want to
color
A1 with the most "important" color from the range (green, white, blue,
red) i
chose based on different critera.
I manage to get the color, but i cant "write" the color to A1. Tried with
.Interior.ColorIndex but nothing :(

Anyone can help?

Thanks