Hello,

First thank you for your reply. I think i didnt express my question well.
Acutally i dont need to color within a cell because the cells may already
have colors that i should not modify

What i want is kind of highlight the boundary of cell or range of cells
using various (random colours) to differentiate cells or range. I dont want
to change the existing border color either. What is want is similar to what
Excel shows when you click on a cell that depends upon other cells for
example in summation, a kind of blue boundray which appears or if there are
many non continous cells it shows it in various colors.

Is this possible programmatically?

Regards,
Abhilash

"RarrMike" wrote in
message ...

Are these completely random colors, or is it like if the value of the
cell is under 10, you want it green, and if valu eis above 10 is red?
If the latter is true, you can apply conditional formatting to these
cells. To use conditional formatting, highlight the cells you want
formatted, click on Format, then click Conditional Formatting. It is
pretty self-explanatory from that point, however, if you have trouble
just let me know and I can explain it a little further.


--
RarrMike
------------------------------------------------------------------------
RarrMike's Profile:
http://www.excelforum.com/member.php...o&userid=25637
View this thread: http://www.excelforum.com/showthread...hreadid=390481