Inserting Rows and Shifting Formatting Down

Topic

New Reply

Hello,

In my spreadsheet I formatted every other row to be filled in Blue and white.
When I insert a new row it throws off my Blue / white stripe sequence.

For Example:
Before Inserted Row:

Blue
White
Blue
White
Blue

After Inserted Row:

Blue
White
Blue
Blue
White
Blue

Please let me know if there is a way to make Excel fix this. Thanks.

Reply | Quote

Replies

try this

1) Select the area in which you wish to highlight
2) Go to the Format menu and select Conditional Formatting.
3) In Condition 1, select “Formula Is”
4) Next to it, type in “=MOD(ROW(),2)=1”
5) Click on the Format >> Patterns tab.
6) Select the color you want
7) OK >> OK

The area you selected should have every other row showing color you have selected
If you add or delete a row, the shading remains consistent

The attached shows what you are after

Reply | Quote

Maybe I need a little help understanding your directions.
Your attached file is exactly what I want, but I can’t seem to get this to work on my file.
Thanks very much,
HandyAndy

try this

1) Select the area in which you wish to highlight
2) Go to the Format menu and select Conditional Formatting.
3) In Condition 1, select “Formula Is”
4) Next to it, type in “=MOD(ROW(),2)=1”
5) Click on the Format >> Patterns tab.
6) Select the color you want
7) OK >> OK

The area you selected should have every other row showing color you have selected
If you add or delete a row, the shading remains consistent

The attached shows what you are after

Reply | Quote

Maybe I need a little help understanding your directions.
Your attached file is exactly what I want, but I can’t seem to get this to work on my file.
Thanks very much,
HandyAndy

At which part of the above you are not sure of?
or you can use the attachment I have provided

Open the attachment
Select the area highlighted
Go to the Menu bar
Select Format, then choose Conditional Formatting

from there, you will see how the formatting can be done.

Let me know if you still can’t get it.

Reply | Quote

Nevermind, I got it to work, Thanks.
I forgot to first remove the coloring I had on the cells.

Maybe I need a little help understanding your directions.
Your attached file is exactly what I want, but I can’t seem to get this to work on my file.
Thanks very much,
HandyAndy

Reply | Quote