Table of Contents
In Google Sheets, there is a feature that allows users to easily identify and highlight the lowest value within a set of data. This feature can be accessed through the “Conditional Formatting” menu, where users can set a condition to highlight the lowest value in a specific range of cells. This is a useful tool for analyzing and comparing data, as it allows for quick identification of the lowest value without the need for manual sorting or calculations. By utilizing this feature, users can efficiently highlight and analyze the lowest values in their Google Sheets data.
Highlight Lowest Value in Google Sheets
You can use the custom formula function in Google Sheets to highlight the lowest value in a range.
The following example shows how to use the custom formula function in practice.
Example: Highlight Lowest Value in Google Sheets
Suppose we have the following dataset in Google Sheets:
Suppose we’d like to highlight the lowest value in the Points column.
To do so, we can highlight the cells in the range B2:B11, then click the Format tab, then click Conditional formatting:
In the Conditional format rules panel that appears on the right side of the screen, click the Format cells if dropdown, then choose Custom formula is, then type in the following formula:
=B2=MIN($B$2:$B$11)
Once you click Done, the cell with the lowest value in the Points column will be highlighted:
By default, Google Sheets uses a light green background as the conditional formatting style.
However, you change the conditional formatting to appear however you’d like by changing the default settings in the Formatting style box.
Note: If there are multiple cells in a range that share the lowest value, each of these cells will be highlighted.
Cite this article
stats writer (2024). How can I highlight the lowest value in Google Sheets?”. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-highlight-the-lowest-value-in-google-sheets/
stats writer. "How can I highlight the lowest value in Google Sheets?”." PSYCHOLOGICAL SCALES, 25 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-highlight-the-lowest-value-in-google-sheets/.
stats writer. "How can I highlight the lowest value in Google Sheets?”." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-highlight-the-lowest-value-in-google-sheets/.
stats writer (2024) 'How can I highlight the lowest value in Google Sheets?”', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-highlight-the-lowest-value-in-google-sheets/.
[1] stats writer, "How can I highlight the lowest value in Google Sheets?”," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I highlight the lowest value in Google Sheets?”. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.