Format cells

[Guest]

How can I format cells that are included in a formual? For example: I sum up 4 cells in a range of cells to come up with a value in the formula cell. I want the cells that are in that formula to display their numbers in a certain color so when I look at the range, I know which cells are in that formula.

 

[Frank Kabel]

Hi
enable the toolbar for 'Track precedents'

--
Regards
Frank Kabel
Frankfurt, Germany

How can I format cells that are included in a formual? For example:

I sum up 4 cells in a range of cells to come up with a value in the
formula cell. I want the cells that are in that formula to display
their numbers in a certain color so when I look at the range, I know
which cells are in that formula.

 

[Guest]

That only shows arrows to the cells included in the formula. I want the numbers in those cells to be a certain color. Can that be done?

 

[Frank Kabel]

Hi
AFAIK not without programming this on your own