Forum Discussion
MRG0tho
Jul 08, 2022Copper Contributor
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...
SergeiBaklan
Jul 09, 2022Diamond Contributor
It depends on which kind of rule do you use and is it initially applied to the cell/row or to the range. Formula rule applied to the range usually accepts new row inserting without adding new rule.