How to conditionally format numbers between two numbers in Excell

Jim Hurdstrom 0 Reputation points
2026-10-16T07:56:14.6833333+00:00

I'm having trouble in conditional formatting of a cell with values (numbers) between and including two numbers. Example: Highlight a cell whose number value is between 1 and 4 inclusive.

Microsoft 365 and Office | Excel | For home | Windows
0 comments
Answer accepted by question author

AI answer

2026-10-16T07:56:59.0933333+00:00

Select the cells, then apply Excel’s built-in Between conditional-formatting rule with 1 as the lower value and 4 as the upper value; both endpoints are included.

  1. Select the cell or range you want to format.
  2. Go to Home → Conditional Formatting → New Rule.
  3. Choose Format only cells that contain.
  4. Under Format only cells with, select:
    • Cell Value
    • between
  5. Enter 1 in the first value box and 4 in the second.
  6. Select Format, choose a fill color or other formatting, and select OK twice.

Cells containing 1, 2, 3, or 4 will be highlighted; values below 1 or above 4 will not. This is the documented numeric Between rule in Excel for Windows.^1^

If the limits are stored in cells—for example, minimum in D1 and maximum in E1—enter =$D$1 and =$E$1 in the two value boxes instead.

References

  1. Windows
AI-generated content may be incorrect. Read our transparency notes for more information.

Was this answer helpful?

1 person found this answer helpful.

0 additional answers

Sort by: Most helpful
Most helpful Newest Oldest

Your answer

Answers can be marked as 'Accepted' by the question author and 'Recommended' by moderators, which helps users know the answer solved the author's problem.