Highlight Odd and Even Numbers

You may wish to highlight odd and even numbers for a range of reasons. Fortunately Excel has a formula for both add and even numbers. Additionally conditional formatting can be used to highlight odd and even numbers in Excel.  

The Excel formula to achieve this is as follows;

=ISODD(A2)

The result will display True if the cell contents of A2 is an odd number.  At the same time; 

=ISEVEN(A2) 

will display True if the cell contents of A2 is an even number.

This can be leveraged with Excel's Conditional Formatting as a condition (Colour, style) will display if the argument is True.  As the numbers are typed in above they turn blue for odd or pink for even.  Attached is a Excel file showing a working example of the above.