auto format table

[Guest]

In Excel 2002 there are limited options for autoformat. I want to
automatically highlight or color every other line of the chart. Is this
possible?

 

[MartinW]

Hi Lois,

Take a look at Row Striping here. (as well as a few others)
http://xldynamic.com/source/xld.CF.html

HTH
Martin

 

[Guest]

Format>>Conditional Formatting>>Formula is :
=MOD(ROW(A1),2)=1
Format>Pattern, choose the color of choice> OK.

 

[Guest]

This is incredible. Thanks so much!

Hi Lois,

Take a look at Row Striping here. (as well as a few others)
http://xldynamic.com/source/xld.CF.html

HTH
Martin