auto format table
 

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?

auto format table
 

Hi Lois,

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

HTH
Martin


"Lois" wrote in message
...
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?

auto format table
 

FormatConditional FormattingFormula is :
=MOD(ROW(A1),2)=1
FormatPattern, choose the color of choice OK.
--
Can''''t hear the Rain ?
Then listen to it.


"MartinW" wrote:

Hi Lois,

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

HTH
Martin


"Lois" wrote in message
...
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?

auto format table
 

This is incredible. Thanks so much!

"MartinW" wrote:

Hi Lois,

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

HTH
Martin


"Lois" wrote in message
...
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?