Home

Conditional Formatting - Inserting rows adds new conditional formatting entry to table

%3CLINGO-SUB%20id%3D%22lingo-sub-661050%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20-%20Inserting%20rows%20adds%20new%20conditional%20formatting%20entry%20to%20table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-661050%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20a%20spreadsheet%20(Table)%20regularly%20for%20tracking%20purposes.%20I%20have%20set%20a%20Conditional%20formatting%20rule%20to%20highlight%20multiple%20columns%20of%20the%20table%20to%20indicate%20if%20the%20fields%20are%20blank%20(as%20a%20reminder%20they%20still%20need%20to%20be%20populated).%3C%2FP%3E%3CP%3EThe%20spreadsheet%20is%20sorted%20by%20program%2C%20and%20I%20regularly%20insert%20new%20rows%20within%20the%20table%20(never%20at%20the%20bottom%2C%20always%20somewhere%20within%20the%20table).%20Every%20time%20I%20insert%20a%20row%2C%20a%20new%20conditional%20formatting%26nbsp%3Brule%2C%20identical%20to%20the%20existing%20rule%2C%20is%20created%20to%20reference%20the%20new%20row.%20I%20end%20up%20with%20hundreds%20of%20conditional%20formatting%20rules%2C%20instead%20of%20the%203%20original%20rules%20I%20created.%20I%20don't%20want%20the%20rules%20to%20extend%20outside%20the%20table%2C%20so%26nbsp%3BI%20have%20tried%20to%20use%20the%20Name%20Manager%20to%20label%20each%20column%20and%20then%20create%20the%20conditional%20formatting%20rules%20using%20the%20name%20labels%2C%20but%20can't%20figure%20out%20how%20to%20make%20it%20work.%20Is%20this%20feasible%3F%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-661050%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EConditional%20Formatting%20and%20Name%20Manager%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
gwynbell
Occasional Visitor

I use a spreadsheet (Table) regularly for tracking purposes. I have set a Conditional formatting rule to highlight multiple columns of the table to indicate if the fields are blank (as a reminder they still need to be populated).

The spreadsheet is sorted by program, and I regularly insert new rows within the table (never at the bottom, always somewhere within the table). Every time I insert a row, a new conditional formatting rule, identical to the existing rule, is created to reference the new row. I end up with hundreds of conditional formatting rules, instead of the 3 original rules I created. I don't want the rules to extend outside the table, so I have tried to use the Name Manager to label each column and then create the conditional formatting rules using the name labels, but can't figure out how to make it work. Is this feasible? Thanks!