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 representing 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 and greater than or equal to 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 and greater than or equal to
a Red Circle With Border icon is displayed for values less than
When done you should see that grades less than have a red stop light icon, grades in the s have a yellow stop light icon, grades greater than or equal to and less than have a gray stop light icon, and grades 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
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
