Conditional Format: – Apply color to highlight alternate rows or columns Automatically in Microsoft Excel
Adding a color to alternate rows or columns (often called color banding) can make the data in your worksheet easier to scan. To format alternate rows or columns, you can quickly apply a preset table format. By using this method, alternate row or column shading is automatically applied when you add rows and columns.

This tutorial will show you to shade every row or column using conditional formatting in a very simple formula. Shading rows or columns with alternating colours is an easy way to make your spreadsheet more legible and less confusing. In this tutorial you will see how simply you can do it using Row, Column, Isodd and Iseven formula.

Hashtag: #highlightcolumn #highlightrow #formatfunction #formatformula #excel #microsoftexcel

Please take the opportunity to connect and share this video with your friends and family if you find it useful.