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>
=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>