Creating Your Own Conditional Formatting Rules in Excel 2007

In the past few posts, we looked at Excel’s conditional formatting feature. Rather than using the pre-defined conditional formatting rules however, Excel 2007 allows you to create your own formatting rules. Using the New Formatting Rule dialog box, you can create custom rules based on specific values, based on top or bottom ranking, above or below average ranking, duplicate values, or even a formula to determine which cells to format.

To display the New Formatting Rule dialog box, click the Conditional Formating button and select More Rules. Clicking More Rules on any of the Conditional Formatting menus will also display the dialog box.

To Create a New Formatting Rule

1. Select the cell range you wish to format.
2. Click the Home tab on the Ribbon.
3. Click the Conditional Formatting button on the Home Ribbon and click New Rule.
4. Click the Rule Type in the top pane.
5. Specify any desired rule criteria.
6. Click the Format Style arrow and choose the style you want from the list.
7. Click the Format button (if available) to display the Format Cells dialog box to add additional formatting such as fill color, border options, font color, etc.
8. Click OK when finished.

Similar Posts:

None Found

Tagged as: Excel 2007 Tips, Microsoft Office Tips