How to Use the Excel MOD Function to Get the Reminder
Excel MOD Function is located in Math and Trig category which allows you to quickly returns the remainder of two numbers after the division.
MOD-Function
How to Apply Alternate Color Shading Between Rows in Excel
Conditional Formatting gives decorative look on active worksheet. This feature allows you to apply alternate color shading between rows.