Excel® 2013 On Demand

Applying Conditional Formatting

You can make your worksheets more powerful by setting up conditional formatting, which lets the value of a cell determine its formatting. For example, you might want this year’s sales total to be displayed in red and italics if it’s less than last year’s total, but in green and bold if it’s more. The formatting is applied to the cell values only if the values meet the condition that you specify. Otherwise, no conditional formatting is applied to the cell values. With Excel, you can apply conditional formatting only to cells that contain text, number, or date or time values. You can quickly format only top or bottom ranked values, values above or below average, unique or duplicate values, or use a formula to determine ...