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".