ExcelBanter - highlight cells that are included in calculated cell

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - highlight cells that are included in calculated cell (https://www.excelbanter.com/excel-discussion-misc-queries/264267-highlight-cells-included-calculated-cell.html)

highlight cells that are included in calculated cell

I have a cell with a calculation in it. I want to hightlight the cells that
are included in the calculation.

highlight cells that are included in calculated cell

click on the cell and touch CNTRL+[
--
Gary''s Student - gsnu201003

"Cell Calculation" wrote:

I have a cell with a calculation in it. I want to hightlight the cells that
are included in the calculation.

Quote:

Originally Posted by Cell Calculation (Post 955215)

I have a cell with a calculation in it. I want to hightlight the cells that
are included in the calculation.

option 1:

To do it manually, press the F5 key to bring up the GoTo dialog. Click the Special Cells button. On the next screen, select Formulas (it's an option on the right).

Excel will select all of the cells that match. Now it's just a matter of applying formatting.

option 2:

Excel has a built in feature of "Trace Dependents" (which shows arrows to show you the calculated cells)

Select the range containing your data.
Excel 2007 - Formulas - Trace Dependents

all the best