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.
To remove all conditional formatting rules from a column, click in the column and choose.
To remove all conditional formatting rules from a worksheet, click in the worksheet and choose.
To remove a conditional formatting rule from a column, click in the column and choose. Select the rule from the list and click the Delete button .
To remove cell formatting that was applied manually, instead of through conditional formatting rules, select the cells and choose.
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.
You can search for cells that have a specific formatting.
You can replace values in cells that have a specific formatting.