Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
To alternate row colors in Excel ...
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
You can’t perform that action at this time.