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

highlight linked cells in a worksheet

P

pradhishnair

New Member
is their any conditional formatting technique where in i can highlight the cells which are linked to another cells. really indispensable please help.
 
Hi Pradish ,


A built-in feature of Excel is that if you double-click in any cell which contains a formula , all the precedent cells are highlighted.


Conversely , if you place the cursor on a cell , and press CTRL G ( GoTo ) , and select Dependents , all the Dependent cells will be highlighted.


Narayan
 
Hi Narayan, hope you would not mind if I say something!


Hi Pradish,


If Narayan got you to what you wanted, then please ignore.


I have a feeling that what you want is, to highlight all cells in a spreadsheet which has got formula (any cell that is linked to other cells, will have formula in order to be able to be linked to other cells).


On your spreadsheet, hit Ctrl+G, Click on "Special", click on "Formulas" and click on "OK", button. All the cells on your sheet that have got formula, will be selected. Please do not click anywhere on the sheet, first apply a background color of your choice. All the cells selected in previous step, will be highlighted with the background color you applied.


Hope this helps!
 
You must log in or register to reply here.
Back
Top