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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
How to reset every other row color after sorting 2
Background stays when sorting 2
How to sort rows by Colors 5
Sorting within Groups 3
Can I sort in Excel and leave the formatting (color) in place? 1
Shading every other row 8
Sorting by Color in Excel 2003 5

Back
Top