Question: Create and apply a new conditional formatting rule for the selected cells F 3 :F 3 3 . Apply the default icon set Three traffic

Create and apply a new conditional formatting rule for the selected cells F3:F33. Apply the default icon set Three traffic lights (unrimmed) icon set, but show only the icon, not the cell value. Change the values so the green circle icon (the first icon) will be applied if the cell value is >=75 percent and the yellow circle icon (the second icon) will be applied if the cell value is <75 and >=25 percent.

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 Programming Questions!