Excel Data AnalysisLesson 49Free preview
Excel Color Scales
This lesson is part of Excel · All levels
Summary
Color Scales give the cell's background color based on value, usually from red (low) to green (high) or vice versa. The two- or three-color scale makes the data patterns look instantaneous without reading the numbers one by one. The color threshold setting can be adjusted by custom rules.
Key points
- Color Scales map the value to the color gradation
- Common scale: red-yellow-green or green-yellow-red
- Available on a two-color and three-color scale
- The data pattern is read quickly through color gradation
Full lesson
Code examples and quizzes
Full lessons, code examples, and quizzes are available to subscribers. 5 questions.