Conditional Formatting ABSOLUT

%3CLINGO-SUB%20id%3D%22lingo-sub-2404441%22%20slang%3D%22en-US%22%3EConditional%20Formatting%20ABSOLUT%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2404441%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20large%20discussion%20tracker%20file%20edited%20weekly%2C%20registering%20dates%2C%20responsibles%2C%20deadlines%2C%20topis%20status%2C%20etc.%20I%20use%20conditional%20formatting%20to%20cells%20to%20highlight%20main%20topics%2C%20actual%20date%20discussions%2C%20and%20all%20the%20above%20I%20mentioned.%20All%20my%20conditional%20formatting%20refers%20to%20and%20valid%20to%20the%20entire%20worksheet.%3C%2FP%3E%3CP%3EMy%20problem%20is%2C%20that%20when%20editing%20weekly%20this%20table%20-%20as%20the%20discussion%20goes%2C%20I%20copy%20cells%2C%20insert%20rows%2C%20etc.%2C%20and%20as%20a%20result%2C%20my%20conditional%20formatting%20are%20getting%20multiplied.%20After%20a%20session%2C%20my%20original%206%20conditional%20formats%20increases%20to%2060%20or%20more.%20After%20a%20few%20sessions%20my%20formats%20goes%20up%20to%20a%20level%2C%20when%20excel%20starts%20to%20overflow%20with%20these%20unnecessary%20copied%20formats.%3C%2FP%3E%3CP%3EMy%20question%20is%2C%20how%20can%20I%20stop%20excel%20to%20copy%20and%20insert%20new%20conditional%20formats%2C%20and%20keep%20the%20original%206%20as%20a%20static%20conditional%20formatting%2C%20so%20that%20I%20do%20not%20have%20to%20clear%20all%20formats%2C%20and%20redo%20the%20original%206%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2404441%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

I have a large discussion tracker file edited weekly, registering dates, responsibles, deadlines, topis status, etc. I use conditional formatting to cells to highlight main topics, actual date discussions, and all the above I mentioned. All my conditional formatting refers to and valid to the entire worksheet.

My problem is, that when editing weekly this table - as the discussion goes, I copy cells, insert rows, etc., and as a result, my conditional formatting are getting multiplied. After a session, my original 6 conditional formats increases to 60 or more. After a few sessions my formats goes up to a level, when excel starts to overflow with these unnecessary copied formats.

My question is, how can I stop excel to copy and insert new conditional formats, and keep the original 6 as a static conditional formatting, so that I do not have to clear all formats, and redo the original 6?

1 Reply
not sure if it will work if yo format your table as a table and from there keep formating