Can I save conditional formatting rules for use in other workbooks? [Excel 2010]

I frequently use conditional formatting to shade alternate rows.

I use
(1) Home>Conditional Formatting>Use a formula to determine which cells to format;
(2) Type in "=MOD(ROW(),2)=1";
(3) And apply a light gray shade so that it will work on the screen and when I print from my old B&W LaserJet.

Every time I do this I have to search for the correct formula, then go through the steps to create a new rule. I grant that this doesn't take a huge amount of time but it'd be much easier if I could some how save the rule for use in any workbook.

Is it possible to do so?

Thanks for any suggestions.

Hi Ted,

Maybe a simple macro will be easier to implement on the long term,

Something like this maybe:

Please Login or Register  to view this content.

abousetta