Trying to highlight cells

G

Guest

I am currently trying to highlight cells that the formula cantains a cell
that was changed within another worksheet thru multiple formula calculations.

For example, in sheet A I have a list of data. This value is then used in
approx. 20 other cells and worksheets (all are within the same workbook) by a
direct formula and also by indirect formulas. I would like to highlight all
the cells that are affected by me changing the one value to another value.
 
G

Guest

hi,
excel has a built in function to do this.
try tools>forumula auditing>?
you will get a lot of options. play with it. I am sure that what you want is
there.

regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a formula to highlight a row of cells 3
Possible to highlight cells depending on value from vlook up? 11
help Fill formulas, highlight cells to specified destination 1
Conditional Format with Name Range? 1
How to highlight cells... 3
Paste Values in linked Cells Only 4
Highlight Changes within cell 1
Automatically Copy formatting (I.E. shading) 2

Top