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?
