Chat with us, powered by LiveChat

Excel Conditional Formatting Formula

How to Use Conditional Formatting with Formulas in Excel

Using formulas to trigger conditional formatting gives you even more control over the presentation of your data.

Use Formulas with Conditional Formatting

  1. Select the range you want to format.
  2. Click the Conditional Formatting button on the Home tab.
  3. Select New Rule.
    Use Formulas with Conditional Formatting

    The New Formatting Rule dialog box appears.

  4. Select Use a formula to determine which cells to format.
  5. Enter a formula in the Format values where this formula is true field.
  6. Click the Format button.
  7. In the Format Cells dialog box, specify the formatting you want to use and click OK.
    Use Formulas with Conditional Formatting

    A preview of the selected format displays at the bottom of the dialog box.

  8. Click OK in the New Formatting Rule dialog box to save the custom rule.

The custom conditional formatting rule is saved.

FREE Quick Reference

Click to Download