• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to highlight (cells from other sheet) while editing formula

E

Ethun_Hunt

New Member
Hi, I am using "top-100-cities-chart" sheet by chandoo to convey my query. When a cell is selected and in edit mode, the cells used in the formula gets highlighted if they are from same sheet. For example (see following image) cell K6 is selected from sheet "data" and cells used in the formula are highlighted with red, blue and purple color rectangles.
Highlighted cells from same sheet.jpg
But when formula contains the cell from other sheet it will not be highlighted. For example (see following image) cell D5 from sheet"Chart" is selected. The cell uses X6 cell from sheet "data" but it is not highlighted when we are editing formula in cell D5 from sheet "Chart". It will be very helpful to debug the sheets if it was possible to highlight cells from other sheet while editing the formulas in cell. Is there any way to do this?
Cells from other sheet not highlighted.jpg
Thanx for your time :-)
 
Hi @Ethun_Hunt
Welcome to the forum :awesome:

I think it is not possible to see the highlighted cells (in edit mode) which are referred to other sheet, may be some add-in(s) available on web, not sure though.

Experts around may have better advice.

Regards,
 
You must log in or register to reply here.
Back
Top