Answered step by step
Verified Expert Solution
Question
1 Approved Answer
9 . 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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started