How to conditionally format numbers between two numbers in Excell

Question

How to conditionally format numbers between two numbers in Excell

Jim Hurdstrom 20

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.

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

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.

Select the cell or range you want to format.
Go to Home → Conditional Formatting → New Rule.
Choose Format only cells that contain.
Under Format only cells with, select:
- Cell Value
- between
Enter 1 in the first value box and 4 in the second.
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

Windows