title: Excel not keeping formatting in table
body: <p>I currently have the following table <img src="https://i.stack.imgur.com/zpDPO.png" alt="enter image description here"></p>
  
  <p>When I attempt to add a row at the top I click on row 4, and then click insert. This gives me the following screenshot<img src="https://i.stack.imgur.com/qbCtT.png" alt="enter image description here"></p>
  
  <p>As you can see, all the colors and formatting has kept except the very first cell. While it looks like I have it selected it is actually the default light (or slightly darker light) blue. I even have the option "format same as above" yet this still happens. How could I fix this?</p>
  
  <p>I should also state that there are no rules set for conditional formatting</p>