excel set the maximum value of the table and the minimum value of the specific steps are as follows:

We need to prepare the materials are: computer, excel

1, first of all, we need to open the editing of excel, select the form and click on the top of the "Conditional Format" option.

2, and then we click on the page "highlight the cell rules" option.

3, after we click on the page "greater than" or "less than" option to set the maximum and minimum values of the table.