A color scale:
A)highlights cells meeting specified criteria with a specified color,font,or border.
B)is a conditional format that displays an colored icon representing a value in the top third,quarter,or fifth based on colors in the selected range.
C)calculates an aggregate for values in a range or database.
D)is a conditional format that displays a color based on the relative value of the cell contents.

Question

Quizplus · Accepted Answer

A color scale is a conditional format that displays a color based on the relative value of the cell contents. It can be used to quickly identify highs and lows in a dataset.

A Color Scale