Google Sheets: Conditional Formatting if Cell is Greater Than or Equal to


You can use the custom formula function in Google Sheets to apply conditional formatting to cells based on whether or not another cell contains specific text.

The following example shows how to use the custom formula function in practice.

Example: Conditional Formatting if Another Cell Contains Text in Google Sheets

Suppose we have the following dataset in Google Sheets that shows the number of points scored by various basketball players during three different games:

Now suppose that we would like to apply conditional formatting to each cell in the dataset that has a value greater than or equal to 20.

First, type the value 20 into cell B11:

Next, highlight the cells in the range B2:D9, 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>=$B$11

Google Sheets conditional formatting if cell is greater than or equal to value

Once you click Done, each of the cells in the range B2:D9 that have a value greater than or equal to 20 will be highlighted with a green background:

If you change the value in cell B11 to a different number, the conditional formatting rule will automatically update.

For example, suppose we change the cutoff value in cell B11 to 30:

Notice that each of the cells in the range B2:D9 that have a value greater than or equal to 30 are now highlighted with a green background.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

Google Sheets: Conditional Formatting If Date is Before Today
Google Sheets: Conditional Formatting with Multiple Conditions
Google Sheets: Conditional Formatting Based on Multiple Text Values

Leave a Reply

Your email address will not be published. Required fields are marked *