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;
The result will display True if the cell contents of A2 is an odd number. At the same time;
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.