Alternate Row Color with Conditional Formatting in Excel
A great Excel trick to alternate row color using Conditional formatting.
Steps:
1. Highlight range
2. Alt + H + L + R to bring up Conditional Formatting menu
3. Create new rule
4. Click "use a formula to determine which cells to format."
5. Type =MOD(ROW(),2)=1
6. Format however you'd like (I chose gray shading in the video)
7. Click OK a bunch of times
That's it! Now your row color alternates in the range. Great for dashboards and other outputs.
A couple ways to get to know me better⤵️
Subscribe to my free email series the Financial Modeling Educator, and go in-depth on topics like this: https://financialmodelingeducator.com/
Check out my Financial Modeling Courses as featured on Wall Street Prep and the Wharton Online Private Equity Certificate Program: https://www.financialmodelingeducatio...
Thanks for watching!
—Chris
Watch video Alternate Row Color with Conditional Formatting in Excel online without registration, duration hours minute second in high quality. This video was added by user Chris Reilly | Financial Modeling Education 06 February 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 2,412 once and liked it 69 people.