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
Смотрите видео Alternate Row Color with Conditional Formatting in Excel онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Chris Reilly | Financial Modeling Education 06 Февраль 2024, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 2,412 раз и оно понравилось 69 людям.