Format cells

I

ICARE

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.
 
F

Frank Kabel

Hi
enable the toolbar for 'Track precedents'

--
Regards
Frank Kabel
Frankfurt, Germany

ICARE said:
How can I format cells that are included in a formual? For example:
Click to expand...
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.
 
I

ICARE

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?
 
Top