Skip to content

Instantly share code, notes, and snippets.

@hmcclungiii

hmcclungiii/AlternatingExcelRows

Created July 27, 2014 04:17
Show Gist options
  • Star 1 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save hmcclungiii/823f5ae51597073ac26f to your computer and use it in GitHub Desktop.
Save hmcclungiii/823f5ae51597073ac26f to your computer and use it in GitHub Desktop.
Download ZIP
To alternate row colors in Excel ...
Raw
AlternatingExcelRows
Select a range of cells to format ...
Click Conditional Formatting - Click New Rule
For the rule, enter this ...
=MOD(ROW(),2)=1
Click the format button and select your formatting.
Click OK twice and there you go!
Only one little problem, you can't save your custom formulas, at least I havent figured out how yet.
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment