There aren't any posts currently published in this category.
Unit 21: Conditional Formatting
Formatting allows you to change the way that the data in cells in a worksheet appear on the screen. For example, numbers can be made to appear as currency values or percentages by formatting them accordingly. Microsoft Excel 2010 provides a variation on formatting known as conditional formatting. With conditional formatting, cells can be formatted in different colors schemes. Rather than this formatting being applied to all cells in a range, it is applied selectively and based on specific rules. This type of formatting allows you to see, for example, values that are over a certain amount, or to instantly spot high and low values based on assigned coloring.
As the name suggests, conditional formatting is a type of formatting that is applied to cells or ranges when certain conditions are met. These conditions are set, but can quite often be customized and edited, in rules that have been programmed into Excel. There are two types of conditional formatting – values-based formatting, and trend-based formatting. What Happens with Conditional Formatting With conditional formatting, cells in a specified range are colored or shaded according to certain conditions which are outlined in rules. Values-Based Conditional Formatting With values-based conditional formatting, cells in the range are examined and their shading and coloring is based on whether they meet the conditions of the rule. This type of formatting allows to see whether values in a range are greater than a certain value, less than a certain value, equal a certain value, or fall between a range. You can also display top ten, bottom ten, top 10%, bottom 10%, and above and below averages with this type of formatting. In all cases a dialog box will appear which will allow you to tweak the rule to what is needed. Basically, the dialog box will allow you to specify a rules value and to determine the color of the shading.
Conditional Formatting Top Bottom Rules
Excel Conditional Formatting Video