Table of Contents
Conditional formatting in Google Sheets allows users to automatically highlight cells that meet certain criteria. To highlight values between two specific numbers, follow these steps:
1. Select the range of cells that you want to apply the conditional formatting to.
2. Click on the “Format” tab in the menu bar and select “Conditional formatting” from the drop-down menu.
3. In the conditional formatting panel on the right, click on the drop-down menu next to “Format cells if” and select “Custom formula is” from the list.
4. In the text box below, enter the formula “=AND(A1>=x,A1
Google Sheets: Conditional Formatting Between Two Values
You can use the custom formula function in Google Sheets to apply conditional formatting to cells that have a value between two specific values.
The following example shows how to use the custom formula function in practice.
Example: Conditional Formatting Between Two Values in Google Sheets
Suppose we have the following dataset in Google Sheets:
Suppose we’d like to highlight each of the cells in the Team column where the corresponding value in the Points column is between 12 and 20.
To do so, we can highlight the cells in the range A2:A11, 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:
=AND(B2>=12, B2<=20)
Once you click Done, each of the cells in the Team column where the corresponding value in the Points column is between 12 and 20 will automatically 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.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How do I use conditional formatting in Google Sheets to highlight values between two specific numbers?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-conditional-formatting-in-google-sheets-to-highlight-values-between-two-specific-numbers/
stats writer. "How do I use conditional formatting in Google Sheets to highlight values between two specific numbers?." PSYCHOLOGICAL SCALES, 26 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-conditional-formatting-in-google-sheets-to-highlight-values-between-two-specific-numbers/.
stats writer. "How do I use conditional formatting in Google Sheets to highlight values between two specific numbers?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-conditional-formatting-in-google-sheets-to-highlight-values-between-two-specific-numbers/.
stats writer (2024) 'How do I use conditional formatting in Google Sheets to highlight values between two specific numbers?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-conditional-formatting-in-google-sheets-to-highlight-values-between-two-specific-numbers/.
[1] stats writer, "How do I use conditional formatting in Google Sheets to highlight values between two specific numbers?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use conditional formatting in Google Sheets to highlight values between two specific numbers?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.