Conditional formatting overview

Use conditional formatting to apply formatting to cells in a column of a Minitab worksheet, based on their values.

For example, in the Weight column, cells that contain values greater than 150 have red shading and text.

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.

For each conditional formatting rule, you can assign one of the four predefined formats, or you can create a custom format by specifying the background color, font color, and font style.

You can subset a worksheet by rows that contain cell formatting. Right-click the column and choose Subset Worksheet > Include Rows with Formatted Cells or Subset Worksheet > Exclude Rows with Formatted Cells.


You can also apply formatting to cells manually, regardless of the value. Select the cell, choose Editor > Cell Properties and choose the formatting to apply.

By using this site you agree to the use of cookies for analytics and personalized content.  Read our policy