Conditional Formatting Greater Than or Equal To in Excel

Yes. In Excel for Microsoft 365 on Windows, conditional formatting can highlight cells whose values are greater than or equal to a threshold: create a rule through Home > Conditional Formatting > New Rule, choose “Format only cells that contain,” and set the condition to “Cell Value” and “greater than or equal to.” The comparison includes values exactly equal to the threshold, not just values above it.

What “greater than or equal to” means

The greater-than-or-equal-to comparison is written with the operator >=. It returns true when the value on the left is higher than the comparison value or matches it. For example, if a sales target is 500, values of 500 and 640 meet the condition; a value of 499 does not. Conditional formatting uses that result to apply a visual format, such as a fill color, font color, or border.

The rule changes how qualifying cells look, not the values stored in them. It does not replace a number, calculate a new result, or prevent someone from editing the cell. That distinction matters when a colored cell is being used as an alert: the underlying value remains available to formulas, sorting, and charts.

Excel offers both point-and-click rules and formula-based rules. The built-in rule is usually quickest for a simple comparison. A formula rule is more flexible when the threshold is in another cell, when you want to format an entire row based on one column, or when you need to exclude blanks.

Create a built-in greater-than-or-equal rule

For a straightforward rule on a range of numbers, use the New Formatting Rule dialog. These steps are for Excel for Microsoft 365 on Windows:

Select the cells to format, such as B2:B100. Selecting the range first helps Excel set the rule’s “Applies to” range correctly.
Choose Home > Conditional Formatting > New Rule.
In the New Formatting Rule dialog, select “Format only cells that contain.”
Set the rule description to “Cell Value,” then choose “greater than or equal to” from the comparison list.
Enter the threshold, such as 500, in the value box. Choose Format to set the appearance, then select OK to create the rule.

Excel’s quicker Highlight Cells Rules menu includes a “Greater Than…” option, but that is strictly a greater-than comparison. It does not include values that equal the threshold. To include equality, use New Rule and choose the explicit “greater than or equal to” operator instead. If you already created a “Greater Than…” rule, edit it rather than assuming equality is covered.

On Excel for Mac, select the range and use Home > Conditional Formatting to open the corresponding rule options; dialog wording and layout can vary slightly by release. Excel for the web also supports conditional formatting from the Home tab, though its controls may be arranged differently from the Windows desktop dialog.

Use a formula for a cell-based threshold

A fixed number is convenient until the threshold needs to change. For a threshold kept in a worksheet cell, use a formula-based rule. This makes it possible to update the cutoff by changing the cell rather than reopening the rule.

For example, suppose the values to format are in B2:B100 and the cutoff is in E1. Select B2:B100, choose Home > Conditional Formatting > New Rule, and select “Use a formula to determine which cells to format.” With the selected range beginning at B2 and the threshold in E1, use:

=B2>=$E$1

Choose a format and confirm the rule. B2 is a relative reference, so Excel evaluates B2, B3, B4, and so on for the corresponding cells in the range. The dollar signs in $E$1 lock the threshold reference, ensuring every cell is compared with the same cutoff. If E1 contains 500, a value of 500 in the selected range qualifies.

The formula must be written for the top-left cell of the range the rule applies to. If the selected range instead begins at C5, write the formula using C5 as the relative reference. Using the wrong starting cell can make the formatting appear shifted by one or more rows or columns.

Format a whole row based on one value

Formula rules can format more than the cell that contains the compared value. This is useful for a task list, sales table, or inventory sheet where a row should stand out when its amount meets a target.

Suppose each record occupies columns A through D, the first record is on row 2, and the values to check are in column C. Select A2:D100, open New Rule, and choose “Use a formula to determine which cells to format.” For that selected range and layout, use:

=$C2>=$F$1

Here, the dollar sign before C fixes the check to column C as the formatting rule moves across the row. The row number 2 is not locked, so Excel checks C2 for the first row, C3 for the next, and so forth. The fixed reference $F$1 holds the threshold constant. Choose a fill or other format, and the whole row will receive it whenever its column C value meets or exceeds the value in F1.

For a simpler layout where only the values in C2:C100 need formatting, use the selected range C2:C100 and the formula =C2>=$F$1. The two examples use the same comparison; the difference is which cells the rule applies to and how the references are anchored.

Choose references and handle blanks

Reference style is one of the most important details in formula-based conditional formatting. Relative references adjust as Excel evaluates the rule over the selected range. Absolute references, marked with dollar signs, stay fixed. Mixed references lock only the row or column. A common row-formatting pattern is $C2: column C remains fixed while the row changes.

Blank cells deserve attention, especially when the threshold is zero or below. A blank can behave like zero in numeric comparisons, so a formula rule may highlight an empty cell when the cutoff makes zero qualify. To require a nonblank value as well, combine the blank check with the comparison. Suppose the range is B2:B100 and the threshold is in E1; use:

=AND(B2<>"",B2>=$E$1)

This rule applies only when B2 is not empty and its value is at least the threshold. The relative B2 reference then adjusts for the other rows. If cells contain formulas that return an empty string, this check generally treats those displayed-empty results as empty too. If the worksheet contains text or errors in the compared range, inspect those entries as well; a rule intended for numeric data is clearest and most predictable when the range contains numbers.

Numbers, dates, and percentages

Greater-than-or-equal comparisons are not limited to whole numbers. They work with decimals, currency values, and percentages. A value of 0.25, for instance, is equal to 25% when the cell is formatted as a percentage; number formatting changes the display, not the underlying comparison. Make sure the threshold and the data use the intended scale. A cutoff of 25 is not the same as 25% if the stored values are 0.25.

Excel stores valid dates as serial numbers, so a date comparison can identify dates on or after a cutoff. For example, a due-date column can be formatted when its dates are at least the date entered in a threshold cell. In a formula rule, compare the date cell with a reference to the cutoff cell just as you would compare numbers. Ensure the entries are real Excel dates rather than text that only looks like a date; text dates can sort or compare unexpectedly.

Time values can be compared in the same general way because Excel represents times numerically as fractions of a day. This can be useful for flagging times at or after a stated deadline. As with dates, the display format does not change the underlying value, so check that both the data and cutoff represent the intended date or time values.

Common problems and how to fix them

Values equal to the cutoff are not highlighted: Check that the operator is “greater than or equal to,” not “greater than.” The latter excludes equality.
The wrong cells are colored: Open Home > Conditional Formatting > Manage Rules and inspect “Applies to.” For formula rules, make the relative reference match the top-left cell of that range.
Every row appears to use the same comparison cell: Check whether the row reference is accidentally absolute. For row-by-row evaluation, a reference such as $C2 should leave the row number unlocked.
The rule seems to ignore a changed cutoff: Confirm that the formula points to the intended threshold cell, and that the threshold is stored as a number, date, or percentage in the expected form.
Empty cells receive formatting: Add a nonblank test with AND, or adjust the data range so the rule does not include unused rows.
Another color or style appears instead: The range may have multiple conditional formatting rules. Review their order and formatting in Manage Rules; overlapping rules can affect the final appearance.

In the Rules Manager, inspect both the rule and its “Applies to” range. The manager also lets you edit, delete, or reorder rules. When multiple rules are relevant to the same cell, priority can matter; “Stop If True,” where available for the rule, can prevent lower-priority rules from being evaluated after a matching rule. Use it only when that behavior is intended, since it can change which other formats appear.

When to use a built-in rule instead

Use the built-in “Cell Value” rule when one range is compared with a fixed cutoff and you want a quick, readable setup. It is easier to maintain than a formula when the condition is simply “this cell is at least this number.” Use a formula rule when you need a changing cutoff stored in a cell, row-wide formatting, a nonblank condition, or a more involved logical test.

Conditional formatting is also not the same as filtering or sorting. It visually marks qualifying entries but leaves all rows in place. If you need to show only records that meet a cutoff, use a filter; if you need them ordered, sort the data. You can combine those tools: apply a conditional format to make important values visible, then filter or sort to focus on the matching records.

Frequently Asked Questions

Does greater than or equal to include the exact value?
Yes. A value equal to the cutoff meets the condition, as does any larger value. For example, with a threshold of 100, both 100 and 101 qualify.

Why does “Greater Than…” not highlight equal values?
That Highlight Cells Rules option tests whether a value is strictly greater than the cutoff. Create a New Rule and select “greater than or equal to” when equality should count.

Can I compare each cell with a different threshold?
Yes. Use a formula rule with relative references for both the value and its corresponding threshold, arranged so each row points to the intended pair of cells. Test the top-left row first to confirm the references shift as expected.

Can the threshold come from another cell?
Yes. A formula rule can compare the selected cell with an absolute reference to the cutoff, such as $E$1. Changing the value in that threshold cell updates which entries qualify.

Does conditional formatting change the cell’s value?
No. It changes the cell’s appearance when its rule is true. The number or date remains unchanged, and other formulas continue to use the underlying value.

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.