About conditional formatting rules

Conditional formatting rules determine which cells to format and the formatting to apply. Conditional formatting rules are applied to columns. You can apply more than one rule to a column. For example, for a column of test scores, you can apply one rule that formats cells that have passing scores as green and then apply another rule to the same column that formats cells that have failing scores as red.

Add a conditional formatting rule

To add a conditional formatting rule to a column, do one of the following:
  • Click in the column. Right-click and choose Conditional Formatting, then choose the category and condition.
  • Click in the column. Choose Editor > Conditional Formatting, then choose the category and condition.
  • Choose Data > Conditional Formatting, then choose the category and condition.

Remove conditional formatting rules

To remove all conditional formatting rules from a column, click in the column and choose Editor > Conditional Formatting > Clear Rules > Clear Rules from Selected Columns.

To remove all conditional formatting rules from a worksheet, click in the worksheet and choose Editor > Conditional Formatting > Clear Rules > Clear Rules from Entire Worksheet.

To remove a conditional formatting rule from a column, click in the column and choose Editor > Conditional Formatting > Manage Rules. Select the rule from the list and click the Delete button .

Tip

To remove cell formatting that was applied manually, instead of through conditional formatting rules, select the cells and choose Editor > Cell Properties > Clear Formats.

Edit the formatting for a rule

You can change the background color, font color, and font style for a formatting rule.
  1. Click in the column that contains the rule and choose Editor > Conditional Formatting > Manage Rules.
  2. Select the rule from the list.
  3. Click Format.
  4. Select the format options, then click OK in each dialog box.

Edit conditional formatting rule precedence

You can apply more than one rule to a column. Minitab assigns the highest precedence to the most recent rule. For example, an analysis assigns a rule that shades cells that have values greater than 10 red, then assigns another rule to the same column that shades cells that have values between 8 and 12 green. A cell that has the value 11 is shaded green.

To change the rule precedence for a column, do the following:
  1. Click in the column that contains the rules and choose Editor > Conditional Formatting > Manage Rules.
  2. Select a rule and use the up and down arrow keys to move it higher or lower on the list. Rules that are higher on the list take precedence over rules that are lower.
  3. When the rules are in the correct order, click OK.

Find cells that have formatting

You can search for cells that have a specific formatting.

  1. Click in the worksheet and choose Editor > Find and Replace > Find Format.
  2. In Find style, select the formatting to find.
  3. Click Find Next.

Replace values in cells that have formatting

You can replace values in cells that have a specific formatting.

  1. Click in the worksheet and choose Editor > Find and Replace > Replace Formatted Cell Value.
  2. In Find style, select the formatting to find.
  3. In Replace cell with value, specify the number, text, or date/time string to replace the current value.
  4. Click Replace or Replace All.
By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy