moogthemoog
Board Regular
- Joined
- Nov 17, 2004
- Messages
- 51
Hi
I have a table containing conditional formatting applied to say $A$1:$A$324. Rows 1 to 324 cover all of the table rows.
If I need to delete a table row (say row 317), the Applied to reference will say $A$1:$A$316,$A$318:$A$324
I thought if the data was in a table, the range would not be interrupted, but would continue to apply to all table rows?
Is this just something we have to live with, or is there a fix?
A supplementary question is, is there a way to export/back up the conditional formatting - even to expand the window to show more of the multiple conditional formatting elements would be useful!
Thanks
Jon
I have a table containing conditional formatting applied to say $A$1:$A$324. Rows 1 to 324 cover all of the table rows.
If I need to delete a table row (say row 317), the Applied to reference will say $A$1:$A$316,$A$318:$A$324
I thought if the data was in a table, the range would not be interrupted, but would continue to apply to all table rows?
Is this just something we have to live with, or is there a fix?
A supplementary question is, is there a way to export/back up the conditional formatting - even to expand the window to show more of the multiple conditional formatting elements would be useful!
Thanks
Jon