Which of the following conditional formatting types can you apply to use red fill to indicate cells that have higher values and green fill to indicate lower values?
A) Icon Sets
B) Color Scales
C) Above/Below Average
D) Gradient Bars

Question

Quizplus · Accepted Answer

Color Scales can be used to apply a gradient of colors to a range of cells based on their values. The default color scale uses shades of green for lower values and shades of red for higher values.

Which of the Following Conditional Formatting Types Can You Apply