Prevent Odd Numbers in a Range

http://bit.ly/134F1LR Prevent odd numbers from being entered in a range in Excel. Using the MOD function with Data Validation we can prevent the entry of odd numbers and display a message explaining why to our users.