Look Who it Was Random video

Excel - Easy Greenbar Formatting in Excel - Color Every Other Row - Episode 693

3,365 views · Published 19 February 2009 · 1:33 · Indexed 10 November 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial: Shading for Alternating Rows in Excel.

Welcome back to another MrExcel netcast! In this video, I'll be showing you an easy way to create green bar formatting in Excel 2007. In previous versions of Excel, this was a tedious task involving conditional formatting and the use of the ROW function. But with the new Format As Table feature, it's now just a few clicks away!

To get started, simply select a cell in your dataset and go to the Format As Table option. You'll see a variety of pre-made table formats to choose from. Pick the one that suits your needs and click OK. Voila! Your data is now formatted with alternating green bars. And the best part? You don't have to deal with any complicated formulas or conditional formatting rules.

But what if you don't want the table functionality and just want the green bar formatting? No problem! Just click on Convert to Range and you'll have a normal range with the green bar formatting still intact. It's that easy! No more wasting time trying to manually format your data.

This is just one of the many improvements in Excel 2007 that make data analysis and formatting a breeze. So why not give it a try and see how much time and effort you can save? Thanks for watching and don't forget to subscribe to our channel for more helpful Excel tips and tricks. See you next time on the MrExcel netcast!"

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/


Excel 2007 offers easy greenbar formatting using the table functionality. While the table functionality offers amazing tools that we'll discuss on another day, today's Episode 693 looks at the few clicks necessary to format a range with alternating row formatting.

Table of Contents:
(00:00) Introduction to Excel 2007 trick for green bar formatting
(00:17) Difficulty of creating green bar formatting in past versions
(00:27) Previous method of using conditional formatting
(00:37) Easier method in Excel 2007 using Format As Table
(00:47) Applying special table formatting
(00:57) Converting back to a normal range
(01:07) Quick and easy application of green bar formatting
(01:19) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Applying green bar formatting in Excel 2007
Converting tables to normal ranges in Excel 2007
Converting tables to ranges in Excel 2007
Easy formatting in Excel 2007
Excel 2007 conditional formatting
Excel 2007 green bar formatting
Excel 2007 table functionality
Formatting tables in Excel 2007
How to create alternating row formatting in Excel 2007
Improvements in Excel 2007 for formatting
Mod function in Excel ROW function
Quick green bar formatting in Excel 2007


Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152207/

More from this channel