Previously, when I clicked into an excel formula to edit it, I would see the cells that the formula referenced get highlighted. This was especially helpful as different colors were used for different ranges in the formula. Now, I cannot see any highlighting unless I actually change the range (e.g. A1:20
to A1:A2
. Is there a way to change this feature back?
Old behavior:
New behavior: