Customizing Conditional Formatting

Excel’s preset conditional formatting is great for most conditions, but if you want to set your own parameters and formatting, you can do so by creating a new rule.

Create a Rule

  1. Select the cells to which you want to apply your conditional formatting.

  2. On the Home tab, click the Conditional Formatting button, and choose New Rule from the gallery to display the New Formatting Rule dialog box.

  3. Select the type of rule you want to use.

  4. Enter the information required for that rule, using the values and formatting you want. Each rule requires different types of information.

  5. Select the formatting you want to apply to the cells that meet the conditions you’ve set. If the dialog box contains a Format button, click it, and, in the Format Cells dialog box that appears, specify the formatting you want. Click OK.

  6. Click OK.

  7. Apply any additional rules to the selection.

    Create a Rule

Tip

Tip

To remove conditional formatting, click the Conditional Formatting button on the Home tab, point to Clear Rules, and, from the submenu, choose where you want to remove the rules.

..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset