keep conditional formatting permanent for a colmumn

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…


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

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)