Skip navigation

Using conditional formatting to apply banded rows

Using conditional formatting to apply banded rows: Excel 2016: Conditional Formatting in Depth
Using conditional formatting to apply banded rows: Excel 2016: Conditional Formatting in Depth

Using the MOD and ROW functions, you can write a conditional formatting rule that highlights every 5th row—or 3rd or 4th, etc.—regardless of content.

Resume Transcript Auto-Scroll
Skill Level Intermediate
1h 1m
Duration
70,869
Views
Show More Show Less
Skills covered in this course
Business Spreadsheets Excel Microsoft Office

Continue Assessment

You started this assessment previously and didn't complete it. You can pick up where you left off, or start over.

Start My Free Month

Start your free month on LinkedIn Learning, which now features 100% of Lynda.com courses. Develop in-demand skills with access to thousands of expert-led courses on business, tech and creative topics.

Start My Free Month