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

Follow this topic

Smriti

Last answered:

01 Jul 2021

Posted on:

29 Jun 2021

Conditional formatting exercise

in Advanced Microsoft Excel / Welcome to the Course

1 answers ( 0 marked as helpful)

Martin Ganchev

Instructor

Posted on:

01 Jul 2021

Conditional formatting exercise

Submit an answer

related questions