Formatting excel worksheets

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

Guest

I got an inventory spreadsheet from wizard that I like a lot but as I add
rows to it I lose the alternated shading to the rows. I only know how to fix
it by manually changing the shading of each row, which is very time
consuming. Is there any way to set it up so that the shading automatically
corrects after adding to a worksheet?
 
Highlight the rows you want shaded and go to <conditional forrmatting>.
Choose "Formula is" and enter the following formula:

If the current shaded rows are even numbers enter "=MOD)ROW),2)=0" an
choose the shading pattern you want.

If the current shaded rows are odd numbers, the formula should b
"=MOD(ROW(),2)=1
 
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

alternate row shading on filtered data 2
Cond. Formatting, Mod(Row) and cell conditions 2
formula for CF 5
Formatting rows 10
Conditional Formatting Help 3
How do I maintain alternate row shading after inserting a new row 4
How do I alternate shading of rows, Excel 2007, no new tabs. 1
alternate row shading kept with autofilter 3

Back
Top