Highlight cells or ranges in edit mode (F2) on multiple sheets

Maofig

New Member
Joined
Jul 29, 2009
Messages
1
Hello friends, I'm frequently editing long formulas like this:

=SUMPRODUCT((Info!$W$70:$X$104)*($B6=Info!$A$70:$A$104)*(AC$5=Info!$W$69:$X$69))

When I'm in edit mode (F2) modifying the formula in the current sheet, I can see the used cells and ranges highlighted with different colors in the formula bar and in the sheet and I can easily resize the ranges from the corner points of the highlighted frames.

I want to ask you if you know a way to activate those highlighted frames for the cells and ranges on the other sheets linked in the formula, the make it easy to modify them.

I'm looking for an add-in, a excel internal configuration or a macro, that does not change conditional formating settings, because I found some answers using macros with this problem.

Some time ago I was reading about an add-in that has this feature to help audit complex formulas, but I can't remember its name.

Any help is greatly appreciated! Thanks!
<div_prefs id="div_prefs"></div_prefs><div_prefs id="div_prefs"></div_prefs><div_prefs id="div_prefs"></div_prefs>
 

Some videos you may like

Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

Watch MrExcel Video

Forum statistics

Threads
1,118,877
Messages
5,574,774
Members
412,617
Latest member
mlharris
Top