keep conditional formatting permanent for a colmumn

[clos911]

is there a way to keep the conditional formatting for a column permanent?
it have a color scale condition for row A, I would like its range to be…

A1:A10000 at all times. but after copying and pasting all day on my calc file the formatting range gets jacked up… here’s and example of what it comes out as…

A193:A10000,A1:A51,A54:A191

I try doing special pastes without formatting and it helps but I dont always remember to do so.
any help would be appreciated.

[anon73440385]

AFAIK no way since conditional formatting doesn’t allow for absolute addressing (e.g in your example using $A$1:$A$10000 the $ get stripped off and you end with A1:A10000 after having cklicked OK)