More Excel MOD formula examples:
- Highlight every other row in Excel - how to shade odd and even rows with different colors.
- Shade groups of rows with different colors - how to highlight blocks of 2 or 3 rows.
- Alternate row colors based on change of value - a clever MOD formula to highlight rows when a cell value changes.
- Extract time from date and time values - how to split date and time in separate cells.