hi,

When there is a sum formula applied to a cell for example

cell A5 = Cell A1 + Cell A2 + Cell A3+ Cell A4

and when we click on cell A5 each of the cells that are part of the formula
is given various random (i think so) colours

How can i do the same programatically? My goal is not to apply formula but
to show cells or range of cells in various kind of colours temporarily. I am
looking for a solution where i dont have to work with cell border colours..

Please let me know if my question is not clear.

Any pointers in this regard will be very helpful

Regards,
Abhilash