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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to filter rows data based on background color of individual cells 1
Background stays when sorting 2
Shading every other row 8
How to reset every other row color after sorting 2
autoformat add or change 1
background-color every second row 2
Fill Color 3
Worksheet Layout 2

Back
Top