If you insert a row, the original row is now one row down.

Conditional Formatting may get you close.

Select a bunch of rows then FormatConditional FormattingFormula is:

=MOD(ROW(),2)=1

Pick a color from FormatPatterns and OK your way out.

See if that suits.


Gord Dibben MS Excel MVP

On Wed, 27 Aug 2008 12:24:26 -0400, "TR Young"
wrote:

Is this possible? I want to have certain rows retain a fill color even if I
have to insert a new row above. I don't want the color to jump down; I want
it to stay in it's original row.