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...
8 Tips to Become an Expert in Conditional Formatting for Excel
Tutorial: Become a master of Conditional Formatting in Excel! This tutorial covers 8 tips and trick...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course



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.