How to highlight odd or even numbers in excel?

In the article, the users are going to highlight even and odd numbers present in Microsoft Excel. There are several features in the Excel sheet including conditional formatting, and format cells that the users have to fill any type of color according to their needs. The users can use the formula for even numbers and odd numbers in the new formatting rule dialog box. The users can use select the range in which they want to fill the color in any cell.

Step 1

Deliberate the Excel sheet with the data. First, open the Excel sheet and create the data one by one. In this sheet, type the even numbers and odd numbers randomly and it will create data that the users have to highlight as shown below.

Step 2

In the Excel sheet, the created data is displayed. After creating the even numbers and odd numbers, place the cursor in cell A1 and select all the cells in which the users inserted the data one by one. After selecting all the data in the sheet, place the cursor in the ribbon. Place the cursor in the Home tab and click on the tab that has many options included. On the Home tab, place the cursor and click on the drop-down menu of Conditional Formatting. On this tab, there are many options included. Click on the New Rule button that opens the New Formatting Rule dialog box as shown below.

Step 3

In the dialog box, there are the rules included one by one. Select and click on the rule Use a formula to determine which cells to format like this.

Step 4

In the dialog box, there is the input type and place the cursor on it. Now, type the formula for selecting odd numbers that is =ISODD(A1) which will select only odd numbers randomly. In the dialog box, place the cursor and click on the Format button that opens a new dialog box Format Cells that has the Fill tab like this.

Step 5

In the dialog box, choose any color in the color theme as shown which the users want to highlight only odd numbers then click on the ok button that closes the dialog box of Format Cells. After closing the Format Cells dialog box, the New Formatting Rule dialog box will display as shown below.

Step 6

In the dialog box, click on the ok button that will close the New Formatting dialog box. After closing the dialog boxes, it will highlight only odd numbers with the selected color from color theme randomly as shown below.

Step 7

Like odd integers, the users have to highlight the even numbers like this. In the excel sheet, the data is displayed. After creating the even numbers and odd numbers, place the cursor in the cell A1 and select all the cells which the users inserted the data one by one which the users want to highlight even numbers. After selecting all the data in the sheet, place the cursor in the ribbon. In the ribbon, there are many tabs included in the top corner. Place the cursor in the Home tab and click on the tab that has many options included. On Home tab, place the cursor and click on the drop-down menu of Conditional Formatting. On this tab, there are many options included. Click on the New Rule button that opens the New Formatting Rule dialog box as shown below.

Step 8

In the dialog box, there are the rules included one by one. Select and click on the rule Use a formula to determine which cells to format like this.

Step 9

In the dialog box, there is the input type and place the cursor on it. Now, type the formula for selecting odd numbers that is =ISEVEN(A1) which will select only odd numbers randomly. the dialog box, place the cursor and click on the Format button that opens a new dialog box Format Cells that has the Fill tab as shown below.

Step 10

In the dialog box, click on the ok button that will close the New Formatting dialog box. After closing the dialog boxes, it will highlight only even numbers with the selected color from color theme randomly as shown below.

The users utilized an easy instance to display how can highlight the odd and even numbers with different colors randomly. The users used the necessary tabs which are included in the ribbon. The users have to practice the essential options from the ribbon and modify the data according to their needs.