Formatting excel worksheets

M

maggiemae

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?
 
E

ElsiePOA

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
 
Top