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!

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies