Locking fill colors into rows


T

TR Young

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.
 
Ad

Advertisements

G

Gord Dibben

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 Format>Conditional Formatting>Formula is:

=MOD(ROW(),2)=1

Pick a color from Format>Patterns and OK your way out.

See if that suits.


Gord Dibben MS Excel MVP
 
T

TR Young

I understand that when you insert a row, the original row moves down, but
the row heading stays the same, therefore Excel still sees it as row "X".
If I can lock row "X" to retain properties even if a row is inserted above
it, that is what I am trying to accomplish. The unconditional formatting
would work, but would require a LOT of time. The company where I work is
putting out a book to our customers that has aluminum shapes tied to a
matrix. The matrix gets hard to read, so we wanted to color every 2 lines a
certain color to make it easy to read. Unfortunately, we add items once and
a while, and that would screw up the colors, forcing me to recolor every
time we add something.
 
Ad

Advertisements

G

Gord Dibben

I can't think of a way to allow inserting a row above row 1 and have the new
row be colored.


Gord
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top