https://bugs.documentfoundation.org/show_bug.cgi?id=153506
--- Comment #27 from BDF <[email protected]> --- I observed the same issue in a slightly different way: In my company we use a large table where you enter your finished work. Because the way the file is saved is not very meant for the way we do it, the progress within the file is often not saved. The result is that some workers saved the file to their own PC, edit it over there and just copy the effected lines. This messes with the range/area of the conditional formatting in the original file. The original range is this: =$C$3:$D$1503 The current range of this year (2023-02) is this: =$C$3:$D$55;$C$58:$D$94;$C$96:$D$1503 The end result of last year was this: =$S$3:$T$23;$S$25:$T$109;$S$111:$T$127;$S$129:$T$140;$S$142:$T$215;$S$218:$T$230;$S$232:$T$247;$S$249:$T$254;$S$256:$T$291;$S$293:$T$316;$S$349:$T$356;$S$358:$T$372;$S$374:$T$398;$S$479:$T$598;$S$400:$T$477;$S$318:$T$347;$S$600:$T$606;$S$608:$T$616;$S$618:$T$677;$S$681:$T$696;$S$699:$T$700;$S$721:$T$725;$S$702:$T$719;$S$727:$T$816;$S$818:$T$873;$S$878:$T$934;$S$938:$T$964;$S$966:$T$974;$S$976:$T$978;$S$980:$T$1503 The end goal would be that you could somehow protect the conditional formatting against unwanted changes. I'm not sure if this bug report/feature request has the same core issue, but it sounds familiar enough to me. -- You are receiving this mail because: You are the assignee for the bug.
