Improve Excel Readability: Color Band or Greenbar Your Rows

Avoid eyestrain and make your spreadsheets easy to read by color filling, shading, or banding your row or column sets.

Created by: Angela Kinney
Specializing in Excel and SQL Tips and Tricks

What Will I Learn?

• Use Excel's Table Styles Formatting to easily achieve color banding
• Create rows of alternating color fill for easy reading by using a simple method
• Color sets of rows to enable easier auditing by using this advanced formula
• Use multiple rules to color columns within the formatted row sets of the range
• Understand Excel's MOD function so you can apply it to solve formatting issues

Requirements

• This course was recorded using Microsoft 365 Excel on Windows 11, and is suitable for all Excel skill levels.

Target audience

• Excel beginning, intermediate, and advanced users wishing to reduce eyestrain and make row sets stand out
• Auditors looking for ways to make spreadsheets easier to read
• Excel support staff looking to add this knowledge to their tool box