Alternate Row Color Style

F

freem123

Hi,

This is my very first post to this site, and I'm pretty stoked.

So I want to set up a new style to allow me to alternate row shading.
I have been using the following to alternate row shading:

1.Select the range that you want to format
2.Choose Format, Conditional Formatting
3.In the Conditional Formatting dialog box, select Formula Is from
the drop-down list, and enter this formula:=MOD(ROW(),2)=0.
4.Click the Format button, select the Patterns tab, and specify a
color for the shaded rows.
5.Click OK twice to return to your worksheet.

Now I want to make this a style so I don't have to continuosly cut and
paste this formula to each sheet.

Please help me and show what a guru you are.
 
P

Peo Sjoblom

You can format the workbook to your liking and save it as a template *.xlt,
then when you need it just do file>new>general templates and select it. I
don't think you can use conditional formatting in a style


--

Regards,

Peo Sjoblom

http://nwexcelsolutions.com
 
Top