Excel Forum
Similar Content
Multiple Conditional Formatting Rules for a Cell in Excel
Tutorial: Apply multiple Conditional Formatting rules to a cell or range in Excel. This allows you ...
Make Complex Formulas for Conditional Formatting in Excel
Tutorial: How to make complex formulas for conditional formatting rules in Excel. This will serve as...
Apply Conditional Formatting to Multiple Cells with a Single Formula
Tutorial: How to use a single formula to apply conditional formatting to multiple cells at once in E...

Excel Magic Trick 467: Conditional Formatting every Nth value (Conditional Format)

See how to Conditional Formatting every Nth value using SUMPRODUCT, MOD and ROW functions. See two alternative formulas, each for a different situation.
1.SUMPRODUCT & MOD & ROW for range starting in cell A1
2.SUMPRODUCT & MOD & ROWS functions for range starting in any cell
Sum every 3rd, 26th, etc. value.

Got a Question? Ask it Here in the Forum.