Question: 1 . Jack asks you to identify the articles that contain 5 0 0 words or more, those that contain 4 0 0 words or
Jack asks you to identify the articles that contain words or more, those that contain words or more, and those that contain less than words.
a In the Number of Words column range D:D create a new Icon Set Conditional Formatting rule using the Traffic Lights Rimmed icons.
b Reverse the icon order.
c Display the red traffic light icon in cells with a Number type value greater than or equal to
d Display the yellow traffic light icon in cells with a Number type value greater than or equal to
e Display the green traffic light icon in cells with a Number type value less than
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
