Highlight Odd and Even Numbers
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.