We all know and love the banded rows in Excel tables, Is it possible to replicate this?

When we deal with conditional formatting all we need to get to is **TRUE **or **FALSE**.

For the banded column we need to write a formula that display **TRUE **in one of the rows, and **FALSE **in the next one.

We can use the Row number for this exercise after all each row carries one information and that is the row number. The row number can be Even or Odd.

Excel does have a formula for just this. It is almost like a question.

The **ISEVEN formula** returns **TRUE **or **FALSE** .

The formula we need to use is **=ISEVEN(Row())** in to **cell A1**.

Certainly you can also use the **ISODD formula**

This will return **FALSE **in A1 and if we drag the formula we will see that in the even row numbers this returns **TRUE**.

All we need to do is to put this formula in to a conditional formatting like this:

You need to write the formula first to the starting cell *(where you want to drag your conditional formatting from)*

Then copy the formula from the formula bar to the formatting formula tab.

In this instance we only colored it to boring yellow, but you can be real creative with your formatting of your banded rows.