See http://www.xldynamic.com/source/xld.CF.html#rows

--
__________________________________
HTH

Bob

"JasonH" wrote in message
...
I want to shade every other line in Excel spreadsheet but if I go back and
insert an additional line it duplicates the color of previous line. I
would
like it to switch to alternating colors as if I had not inserted an
additional line.