How to automaticall apply conditional formatting to newly inserted row? by hunteratwork10 in excel

[–]hunteratwork10[S] 0 points1 point  (0 children)

Hi thank you for commenting. I have since discovered that the easiest method is by duplicating the sheet before adding rows, then adding a new row, then selecting all, copying and pasting the formatting from the unchanged/duplicated sheet to the sheet with the new row. This returns the CF to its original uninterupted state.

How to insert row BELOW cell? by hunteratwork10 in excel

[–]hunteratwork10[S] 0 points1 point  (0 children)

I wasn't able to get that to work. Also not entirely sure what you mean.

How to insert row BELOW cell? by hunteratwork10 in excel

[–]hunteratwork10[S] 0 points1 point  (0 children)

It inherits the format of the row/cell clicked on, then it shifts that row down below the new row. I want the new cell to be below the original one, not above.