DEV Community

Abiola Omiyale
Abiola Omiyale

Posted on

How to highlight a cell or cells in Google Sheets for a value or given set of values

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 :

Image description


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

Image description


2. Click 'format' -> 'Conditional formatting' a toolbar will open to the right

Image description

Image description

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."

Image description


3. The cells with values greater than '10' are automatically selected.

Image description


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)