is there a way to autoformat shading in all odd cell numbers?
 

is there a way to autoformat shading in all odd cell numbers?

is there a way to autoformat shading in all odd cell numbers?
 

I'm not competely sure whether you mean odd rows or odd columns but would
this help - http://www.cpearson.com/excel/banding.htm

"tat2f" wrote:

is there a way to autoformat shading in all odd cell numbers?

is there a way to autoformat shading in all odd cell numbers?
 

Conditional Formatting

=MOD(ROW(),2)=1


"tat2f" wrote:

is there a way to autoformat shading in all odd cell numbers?

is there a way to autoformat shading in all odd cell numbers?
 

tat2f wrote:
is there a way to autoformat shading in all odd cell numbers?

Check out this freebie. Lots of real handy features

http://www.asap-utilities.com/


gls858