In this help article, I will be showing you how to highlight a cell in 'Google-sheets' if the number in that cell is greater than 10
Cells, rows, or columns can be formatted to change text or background color if they meet certain conditions in this help article when the number is greater than ten (10).
For this example, I have created a Google-sheets with a list of twenty-two items and their corresponding values, as shown in the image below :
In the values column, we have a minimum value of 1 and a maximum value of 250. Since we are interested in highlighting only the cells with values greater than 10, To do this, do the following :
1. Highlight all the Values Column B
2. Click 'format' -> 'Conditional formatting' a toolbar will open to the right
Select the following format rules in the format rules: format cells if value is "greater than" and value "10"; apply a desirable color; and click "done."
3. The cells with values greater than '10' are automatically selected.
End of article
I hope the help article was helpful in providing the needed information to carry out similar tasks in your worksheets.
Kindly drop your comments and questions in the message box, and I will attend to them.
Top comments (0)