I am trying to run a roll sheet and to help read it I made every other line
light green.
The problem comes when I sort the line color goes with the data entered so I
lose my every other line color. Is there a way around that? I have tried
the format sheet option and come up with the same problem

Hi Proto,

Select all cells in the worksheet by clicking on the square to the left of
the A column heading.

Then use the menu item Formay -- Conditional Formatting...

Change condition 1 to Formula Is

Enter the formula =MOD(ROW(A1),2)=1

Click on Format... and set the pattern colour to light green

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

I am trying to run a roll sheet and to help read it I made every other line
light green.
The problem comes when I sort the line color goes with the data entered so
I
lose my every other line color. Is there a way around that? I have tried
the format sheet option and come up with the same problem