You can use Conditional Formatting to color the borders.
Remove the Conditional Formatting and the colors all
return to normal.

I don't know anything about your seeing different colors
in the cells that are named in the formulas. What version of
Excel do yo have.

You can in any version of Excel see cell dependencies.
tools, customize, left tab is toolbars, click on Auditing toolbars.
You can then check out cell dependencies.


---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"news.microsoft.com" wrote in message ...
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