Shading alternate rows

CherieMac

Is it possible to define a default condition on sheets so alternating rows are shaded? This would improve our readability. Many people add to this sheet, so creating them manually is a major pain.

J. Craig Williams

Do they add at the bottom or in the middle?

 

Craig

 

Joel Johnson

Take a look at this previous discussion in the community.  This will work if they are adding to the bottom of the sheet.

 

https://community.smartsheet.com/discussion/alternating-row-colors

 

CherieMac

We want to add at the top, but haven't figured out how to do that, so we add to the bottom and then sort after each addition. I searched the discussion threads before posting but didn't use the perfect key words!! Thanks.

 

If you know how to add to the top of the sheet, let me know!!!

 

J. Craig Williams

Cherie,

 

If you are using Joel's color formula

 

=IF(Color1 = 0, 1, 0)

 

instead of pointing to the row ABOVE it (this example is for row 2)

point to the one BELOW it

 

=IF(Color3 = 0, 1, 0)

 

and copy that to the rest of the column.

When you add a new row at the top, it will auto-fill AFTER you type in something.

But it will.

 

Craig