How to Highlight Odd or Even Numbers in Excel Using Conditional Formatting

To highlight odd or even numbers in Excel, you can use Conditional Formatting with a formula. Here’s how:

---

✅ Steps to Highlight Odd Numbers:

1. Select the range of cells you want to check.
2. Go to the Home tab → click Conditional Formatting → choose New Rule.
3. Select “Use a formula to determine which cells to format”.
4. Enter the formula: =ISEVEN(A1)=FALSE (Replace A1 with the top-left cell of your selection.)
5. Click Format, choose a color (e.g., light green), and press OK.

---

✅ Steps to Highlight Even Numbers:

Follow the same steps, but use this formula:

=ISEVEN(A1)=TRUE

---

🧠 Explanation:

• ISEVEN(number) returns TRUE if a number is even.
• ISODD(number) returns TRUE if a number is odd.
• Conditional formatting applies the format when the formula returns TRUE.

You can use ISODD(A1) instead of ISEVEN(A1)=FALSE if you prefer.

---