Google sheets are very similar to Microsoft Excel when highlighting numbers that are greater than or less than a number. You can use the conditional formatting built-in Google sheets.
Step 1: Select the numbers 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 "Greater than" and type the boundary number in the box below, e.g., 2;
Step 5: If you want a different color from the default color, you can change the color in the "Formatting style" section;
Step 6: After you click the "Done" button, all the numbers in the selected data range that are greater than the number you entered should be in the proper color, e.g., green;
Step 7: Google sheets set up many rules for formatting numbers, other than "Greater than", you actually have many other rules such as "Less than", "Equal to" and "Is between" etc. Please select the proper rules for your data in the panel.
Step 8: If you want to clear the rules you set up, click "Remove rules" right after the rule;
Step 9: To delete all the formatting rules, you can click the "Format" tab from the ribbon again and click "Clear formatting" from the drop-down list.
