Excel: Conditional Formatting Based on Even and Odd Values

By /

To apply conditional formatting to cells in Excel based on even and odd values, you can use the New Rule option under the Conditional Formatting dropdown menu within the Home tab.

The following examples show how to use this option in two different scenarios:

Scenario 1: Apply Conditional Formatting Based on Even and Odd Values in Cells

Scenario 2: Apply Conditional Formatting Based on Even and Odd Row Numbers

Let’s jump in!

Example 1: Apply Conditional Formatting Based on Even and Odd Values in Cells

Suppose we have the following dataset in Excel that contains information about various basketball players:

Suppose we would like to highlight all cells in the Points and Assists columns that have an even number in them.

To do so, we can highlight the cell range B2:C11, 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 =ISEVEN(B2) in the box, then click the Format button and choose a fill color to use.

Excel conditional formatting based on even and odd numbers

Once we press OK, all of the cells in the range B2:C11 that contain an even number will be highlighted:

We can see that each cell in the Points and Assists columns that have an even number in them are highlighted with a light green background.

Example 2: Apply Conditional Formatting Based on Even and Odd Row Numbers

Once again suppose we have the following dataset in Excel that contains information about various basketball players:

Suppose we would like to highlight all rows in the dataset with an even number.

To do so, we can highlight the cell range A1:C11, 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  =EVEN(ROW())=ROW() in the box, then click the Format button and choose a fill color to use.

Once we press OK, all of the even-numbered rows in the range A1:C11 will be highlighted:

Excel conditional formatting based on even and odd row numbers

Note: We chose to use a light green fill for the conditional formatting in this example, but you can choose any color and style you’d like for the conditional formatting.

Additional Resources

The following tutorials explain how to perform other common operations in Excel:

x

Related posts:

  1. Excel: Conditional Formatting Based on Multiple Text Values
  2. Google Sheets: Conditional Formatting Based on Multiple Text Values
  3. Excel: Apply Conditional Formatting Based on Date in Another Cell
  4. Excel: Apply Conditional Formatting Based on Date
  5. Excel: Apply Conditional Formatting Based on Adjacent Cell
  6. Google Sheets: Conditional Formatting Based on Checkbox
  7. Excel: Apply Conditional Formatting if Between Two Values
  8. Excel: Apply Conditional Formatting to Yes/No Values
  9. VBA: Apply Conditional Formatting to Duplicate Values
  10. Google Sheets: Conditional Formatting Between Two Values
Scroll to Top