How to Highlight Values That Are Greater or Less Than in Google Sheets
When dealing with data in Google Sheets, you may need to highlight a value that is greater or less than another. Conditional Formatting makes this possible. Using this method, a cell’s value may be used to determine its formatting.
Source: alphr.com