Forum Discussion
Conditional formatting and Tables
My Excel 365 doesn't do it (I'm not convinced it used to happen with older versions either)
If I insert a row then copy and paste down the row above it does happen
How are you inserting the row? And are you doing any copy pasting after inserting the row
Wyn
MVP
Wyn, it still inserts extra rules if references in rule formula are out of applied range, like in this case - formula uses S4 but range starts from S5.
SergeiBaklan It assure you this is not the case. I just went in and deleted that rule to check and when I inserted a row it did the same thing.
Just in case, could you please share rule formula?
...actually you might be right. I deleted the two formula rules that had to do with matching one row to another. Once I inserted another row that didn't affect any of the other rules in the sheet.
