Excel® 2013 On Demand

Applying Specialized Conditional Formatting

With Excel, you can apply specialized conditional formatting by using data bars, color scales, and icon sets. A colored data bar helps you see the value of a cell relative to other cells. The length of the data bar represents the value in the cell. A longer bar represents a higher value. A negative value displays a bar on the opposite side of an axis from positive values. A color scale is a visual guide that helps you represent data distribution and variation using two or three color gradients. The color shade represents the value in the cell. A two-color scale represents higher and lower values, while a three-color scale represents higher, middle, and lower values. An icon set helps you annotate and ...