How can I hold every other row color on a sheet when I sort

P

Proto

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
 
E

Ed Ferrero

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
 
Top