Download the featured file here: https://www.bluepecantraining.com/wp-content/uploads/2023/10/color-banded-rows.xlsx

In this step-by-step guide, I'll show you how to easily create alternating row and column colors in Excel with and without using tables. Whether you want to enhance the readability of your spreadsheets or simply give them a more appealing look, I've got the solution for you.

00:00 Introduction
00:17 Use Tables to apply alternating rows and/or columns
01:05 Use conditional formatting for alternating rows
04:09 Use conditional formatting for alternating columns
05:27 Use conditional formatting for alternating rows and columns



#exceltutorial #exceltips