Keep conditional formatting when inserting rows. I go to great lengths to create conditional formats.

Keep conditional formatting when inserting rows. This keeps the CFR in-tact and results in copious happy tears. Jan 17, 2016 · If you insert your rows within the Conditional Formatted range, the Conditional Format will automatically apply to the new row without you having to do anything. I can then copy and paste them back into an excel sheet where the conditional formatting still stays. Jul 26, 2019 · However, you can use INDIRECT() in a conditional formatting rule formula, the same as you can in sheetside formulas. If you have a row with conditional formatting applied selected and you right click to insert a row above/below, the conditional formatting will copy to the new row. I go to great lengths to create conditional formats. edit: That's the existing data The rule isn't technically duplicated, it's been split in half to specifically exclude the inserted row. At the moment, when I insert a new row, it changes the colour of SOME of the existing rows. If you can be a little more specific about 'if something shows up in Column X of that row', I may be able to offer more precise directions. Don't copy/paste formatting as that causes the conditions to get copy Aug 26, 2025 · Brian has a range of cells (let's say 25 rows) that use conditional formatting. ujrglyi kdm dzld 7fn ptwsl7 4q dmvovu lkdu fthj3tw8 sxm0v