Conditional formatting exercise
In the question,Repeat the same task, but consider,
this time, the managers obtained five green lights in the first column and only
three green lights in the second. Company B had a yellow light in the second
column, and Company F had a yellow light in the first column. These are the
only yellow lights observed.
in the solution, why is number assigned to green 0.02 and to amber -0.02?
Hi Smriti!
Thanks for reaching out.
The values delineating green, yellow or red colour, are set by the user in a way that will help express the meaning of the numbers in the table well.
You can refer to the following lecture from the course as a reference:
https://learn.365datascience.com/courses/advanced-microsoft-excel/highlight-key-data-with-excel-conditional-formatting/
Hope this helps.
Best,
Martin