Applying conditional formatting to cells

Conditional formatting means that specific formatting only applies when selected cells meet specific conditions. You can easily find the particular cells that meet the rules.

Steps

To set conditional formatting

  1. Select the cells where you want to modify conditional formatting.
  2. Click Home > Conditional Formatting > Conditional Manager.
  3. In the Conditional Formatting Rules Manager dialog box, click the New Rule  icon to add a new rule.
  4. Specify the condition and formatting you want to apply and click the Set button.
    You can change font, pattern, border, and pattern formatting from the Format Cells dialog that appears when you click the Format button.
  5. Click OK to close the Conditional Formatting Rules Manager dialog box and apply the new rule to the selected range.

To delete conditional formatting

  1. Click Home > Conditional Formatting.
  2. In the Conditional Formatting Rules Manager dialog box, select the rule from the list and then click the Clear Rules  icon.
  3. Click OK to close the Conditional Formatting Rules Manager dialog box and delete the formatting of the selected rule from the worksheet.

You can define and add new rules and you can delete them at any time. The rules you define can be modified or deleted as you need or want.

Steps

To create a new rule

  1. Select a range of cells you want to apply a new rule.
  2. Click Home > Conditional Formatting > Conditional Manager.
  3. Click the New Rule  icon on the Conditional Formatting Rules Manager dialog box to add a new rule on the list.
  4. Select Cell Value or Formula from the drop-down and specify the condition and then click the Format button.
  5. Specify the format in the FontBorder, and Pattern tab of the Format Cells dialog box and then click the Set button.
  6. Click the OK button of Conditional Formatting Rules Manager dialog box.

To delete a rule

  1. Click Home > Conditional Formatting > Conditional Manager.
  2. Select the rule you want to delete from the list.
  3. Click the Clear Rules  icon on the Conditional Formatting Rules Manager dialog box.
  4. Click the OK button of Conditional Formatting Rules Manager dialog box.
Was this article helpful?
0 out of 0 found this helpful