Microsoft Office Tutorials and References
In Depth Information
Creating Conditional Formatting
Creating Conditional Formatting
Instead of using one of the built-in conditional formatting rules, you can create your own
rules. The New Formatting Rule dialog box allows you to create rules based on different
rule types, such as format all cells based on their values, or use a formula to determine
which cells to format. After you select a rule type, you specify the rule criteria to trigger
conditional formatting. Many of the rule types include the Format button, which opens the
familiar Format Cells dialog box. You can specify number, font, border, and fill format-
ting options. For icon sets, you can mix and match icons for a custom look as well as hide
them based on your criteria. For data bars, you can set the bar direction, and specify cus-
tom formatting for negative values.
Create Conditional Formatting Rules
Click the Home tab.
Click the Conditional Formatting button, and then click New Rules .
Click the rule type you want.
• Format all cells based on their values.
• Format only cells that contain.
• Format only top or bottom ranked values.
• Format only values that are above or below average.
• Format only unique or duplicate values.
• Use a formula to determine which cells to format.
Specify the rule criteria you want to create a conditional format. Each rule type
provides a different set of options you can set.
If available, click Format to specify number, font, border, and fill formatting
options in the Format Cells dialog box.
Click OK .
Search JabSto ::

Custom Search