Alternating Row Colors

[RandyD123]

Currently my sheet uses alternating colored row. However when I insert a row and then resort my alternating colors break. Is there a code that will make this happen automatically, no matter how many rows I may insert. It is a list of names address's and phone numbers so I add 1 or 2 at a time, but I may insert as many as 10 rows.

 

[Fluff]

Hi, have a look here
https://support.microsoft.com/en-gb/help/919194/how-to-shade-every-other-row-in-excel

 

[RandyD123]

I am using method "2" and it breaks when I insert rows.

 

[dreid1011]

I am using method "2" and it breaks when I insert rows.

How does it "break" ? I have used this method myself a few times, and testing now.. nothing "broke" when I inserted rows.

 

[RandyD123]

Please disregard....... Apparently someone that had access to my file decided to mess with my CF. All set now. Thanks for the reply's.

 

[Fluff]

Glad we could help