![]() If the value is negative, the background is shaded otherwise, no formatting is applied.Ĭonditional formatting is an easy way to quickly identify erroneous cell entries or cells of a particular type. 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. ![]() Finding tips for using conditional formatting.Using the graphical conditional formats.Getting an overview of Excel's conditional formatting feature.Chapter 21 Visualizing Data Using Conditional Formatting
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |