Resolved: What is the point of this feature?
If I understand, Green references serve a similar function to red underlines in Word. By that I mean, they tell the user about errors in the user's input (strange equation or incorrect spelling). In the video, one cell is flagged as having an error. Despite verifying the equation is correct, Excel still thinks it has an error. I guess I don't understand why such a feature would exist when Excel has other ways to return errors or mistakes (such as the comma vs period example the multiply by 1 video). An easier question to answer may be, if this feature incorrectly flags cells sometimes, what are some situations in which you would want to keep it enabled?
Hi Dylan,
Exactly as you imagine it.
Some instances when green references can be helpful are when Excel thinks you might have made a mistake.
For example if in a column in which you have consistently multiplied
C7=A7*B7
C8=A8*B8
C9=A9*B9
etc.
then you might have another calculation like C10=A1+A2
Excel wants to tell you that you're not consistent and this might be an error you've made.
Hope this helps!
Ah so in other words green references tell you that "you are being inconsistent" rather than "you made an error"?
Submit an answer
