Microsoft Office Tutorials and References
In Depth Information
Chapter 19: Conditional Formatting and Data Validation
Figure 19-5: This table uses data bars conditional formatting.
Figure 19-6: A real Excel bar chart (not conditional formatting data bars).
Using color scales
The color scale conditional formatting option varies the background color of a cell based on the
cell’s value, relative to other cells in the range.
Figure 19-7 shows a range of cells that use color scale conditional formatting. It depicts the
number of employees on each day of the year. This is a three-color scale that uses red for the lowest
value, yellow for the midpoint, and green for the highest value. Values in between are displayed
using a color within the gradient.
This workbook, named color scale example.xlsx , is available on the companion