Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Last answered:

06 Jan 2023

Posted on:

05 Jan 2023

0

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?

3 answers ( 1 marked as helpful)
Instructor
Posted on:

05 Jan 2023

0

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!

Super learner
This user is a Super Learner. To become a Super Learner, you need to reach Level 8.
Posted on:

05 Jan 2023

0

Ah so in other words green references tell you that "you are being inconsistent" rather than "you made an error"?

Instructor
Posted on:

06 Jan 2023

0

Precisely!

Submit an answer