![]() ![]() Get Excel 2016 Formulas now with O’Reilly online learning. You can use a format (such as bright-red cell shading) to make particular cells easy to identify.įigure 19.1 shows a worksheet with nine ranges, each with a different type of conditional formatting rule applied. If not, no formatting is applied.Ĭonditional formatting is an easy way to quickly identify erroneous cell entries or cells of a particular type. If the value is negative, the background is shaded. When you enter or change a value in the range, Excel examines the value and checks the conditional formatting rules for the cell. For example, you can apply conditional formatting in such a way that all negative values in a range have a light-yellow background color. About Conditional FormattingĬonditional formatting enables you to apply cell formatting selectively and automatically, based on the contents of the cells. In some cases, conditional formatting may be a viable alternative to creating a chart. You can apply conditional formatting to a cell so that the cell looks different, depending on its contents.Ĭonditional formatting is a useful tool for visualizing numeric data. This chapter explores the topic of conditional formatting, one of Excel’s most versatile features. Examples of using conditional formatting formulas. ![]() How to use the graphical conditional formats.An overview of Excel’s conditional formatting feature.
0 Comments
Leave a Reply. |