auto format table

Lois · Nov 3, 2007

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 · Nov 3, 2007

Hi Lois,

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

HTH
Martin

The Rain · Nov 3, 2007

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

Lois · Nov 4, 2007

This is incredible. Thanks so much!

MartinW said:
Hi Lois,

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

HTH
Martin