Highlighting alternate rows using conditional formatting

Walter_Pek 

Hi 

To apply banded rows conditional formatting:

1. Select the range to format
2. Home Tab >> Conditional Formatting >> New Rule
3. Use Formula
4. The formula I used is : =MOD(ROW(),2)=1

since the ROW function returns an incremental number >> I divide it by 2 (the divisor) and the MOD returns the REMAINDER 1,0,1,0,1,0...  so the formatting will pop up if it is =1

 This function works in list or tables.

It works also for Banded columns but replace ROW() by Column()

Hope that Helps

Nabil Mourad