Question: Modify the conditional formatting rule you applied in the previous step as follows: a Green Circle icon of type Number is displayed for values greater

Modify the conditional formatting rule you applied in the previous step as follows:
a Green Circle icon of type Number is displayed for values greater than or equal to 0.8(representing 80%). Note: Set the type box to Number before setting the values for the icons, just like you did in the learning activity.
a Gray Circle icon of type Number is displayed for values less than 0.8 and greater than or equal to 0.6(60%). Do not confuse gray with black - make use of the tool tips to help you.
a Yellow Circle icon is displayed for values less than 0.6 and greater than or equal to 0.5(50%).
a Red Circle With Border icon is displayed for values less than 0.5.
When done you should see that grades less than 50% have a red stop light icon, grades in the 50s have a yellow stop light icon, grades greater than or equal to 60 and less than 80 have a gray stop light icon, and grades 80 and above have a green stop light icon.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!