Forum Discussion
Conditional formatting self-edits
If a column has conditional formatting and you insert a row, a new rule is created. It is a copy of the original but only for the new row, while the original rule is edited to exclude the new row. Su...
MRG0tho I have has this sort of issue also but I thought it was more due to a row delete. But in any case those rules do become messy and I even created a macro that would use a template sheet to remove all the rules and re-insert them based on the 'rules' in my template. I attached it here and maybe you can re-work it to help you.