Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Cells A 1 :A 1 0 contain a set of numbers. You want to select those cells that contain numbers less than 1 0 0
Cells A:A contain a set of numbers. You want to select those cells that contain numbers less than and highlight those cells in red, and you want to do it in such a way that even if some numbers change, those cells still get highlighted in red if their value falls below ; otherwise, the cells should not be colored. Which of the following Excel features allows you to accomplish this task?
tableAA
Select the single best answer:
A Filter
B Sorting
C Conditional Formatting
D Pivot Table
E Cell Style
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