Excel Tip: Conditional Formatting

Excel’s built-in conditional formatting gets new powers in Excel 2010. Now you can apply one of the pre-built color-coded conditional formatting options to data that includes negative numbers (not only positive numbers, as in Microsoft Office 2007). This can give you quick graphic clues to the way in which profits and losses, for example, fit into a pattern that’s easier to detect graphically than by looking at a column of numbers. You set this up this kind of conditional formatting by clicking Home, Conditional Formatting, Data Bars, and then choosing a color set in the Gradient Fill gallery.

Comments are closed.