Table of Contents
Conditional formatting if cell is greater than or equal to value is a feature in Excel that allows you to apply a specific formatting to a cell or range of cells if the value of the cell is greater than or equal to a specified value. This feature is useful for highlighting cells that meet a certain criteria and can help to make spreadsheets easier to read and understand.
To apply conditional formatting to cells that are greater than or equal to some value in Excel, you can use the New Rule option under the Conditional Formatting dropdown menu within the Home tab.
The following example shows how to use this option in practice.
Example: Apply Conditional Formatting if Cell is Greater Than or Equal to Value
Suppose we have the following dataset in Excel 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 H1:
Next, highlight the cells in the range B2:D8, then click the Conditional Formatting dropdown menu on the Home tab and then click New Rule:
In the new window that appears, click Use a formula to determine which cells to format, then type =B2>=$H$1 in the box, then click the Format button and choose a fill color to use.
Once we press OK, all of the cells in the range B2:D8 that have a value greater than or equal to 20 will be highlighted:
If we change the cutoff value to a different number, such as 30, then the conditional formatting rule will automatically adjust to only highlight cells with a value greater than or equal to 30:
