How to Highlight the Maximum or Minimum Value in Google Sheets

There are many ways to look at your data when working with Google Sheet. For example, you can highlight the top 10 values or the top 10% values in the data range. However, you may just want to highlight the maximum or minimum values.

Step 1: Select the data column or the data range that you want to highlight;

Step 2: Click the "Format" tab from the ribbon;

Step 3: Click the "Conditional formatting" from the drop-down list;

Step 4: On the right of your spreadsheet, you will see the "Conditional format rule" panel. In the "Format rules" box, select "Is equal to" and copy the formula =MAX(A$1:A$10) in the next box to highlight the maximum value;

- Please use the formula =MIN($A$1:$A$10) to highlight the minimum value.

Step 5: If you want a different color from the default color, you can change the color in the "Formatting style" section, e.g., "green";

Step 6: Click the "Done" button, the cell with the maximum value will be in green (or the minimum value if you use the MIN function in step 4);

Step 7: You can highlight both the maximum and the minimum values in the data column by "Adding another rule".

Leave a Reply