Color every other row

  • Thread starter Thread starter Kari
  • Start date Start date
K

Kari

Is there a way to quickly color every other row? I need
it to stay every other row, even after a search.

Thanks
Kari
 
If you use conditional formatting, you can set up the following 3
conditions. All use the "Formula is" option.

Condition 1 =ISBLANK($A16) with No format set
Condition 2 =MOD(ROW(),2)=1 format this colour for ODD rows
Condition 3 =MOD(ROW(),2)=0 format this colour for EVEN rows

The purpose of the first condition is to leave blank rows un-coloured.

If you only want to colour ODD (or EVEN) rows whilst leaving the others
uncoloured you can use condition 1 and condition 2 (or 3)only.

If you don't mind about having blank rows being coloured then omit
condition 1.

Hope this helps

Mike
 
Back
Top