My spreadsheet includes conditional formats unique to each column (ex: Applies to $E$3:$E$50). If I add a row (ex: using insert or copy/insert copied line and row 27 is now inserted), the column format is not included. If I go to another cell in the same column, the 'Applies to' is now automatically set to $E$3:$E$26, $E$28:$E$50). Is there a way to keep the conditional format if I add a row within the column format range which does not require manual manipulation of the conditional format for the new row?
Bookmarks