Microsoft Office Tutorials and References
In Depth Information
Applying Specialized Conditional Formatting
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 pos-
itive 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 rep-
resents higher, middle, and lower values. An icon set helps you annotate and classify data
into three to five categories separated by a threshold value. Each icon represents a value in
the cell. You can apply multiple formatting to the same data in order to display the results
you want. In addition, you can refer to values in other worksheets. You can apply a preset
format using the Quick Analysis tool ( New ! ) or apply other conditional formats.
Format Using Data Bars
Select a cell or range you want to conditionally format.
Click the Home tab.
To format with a preset, click the Quick Analysis button ( New ! ), click For-
matting , and then click the Data Bars button.
To format with an expanded menu, click the Conditional Formatting button,
and then point to Data Bars .
Click the colored data bar you want, either gradient or solid fills.
To create a custom data bar, click More Rules , specify the description you
want (including bar direction), and then click OK .
Search JabSto ::

Custom Search