The range for conditional formatting keeps changing and I’m not sure why. I
have a very simple rule like
A3:AMJ1048576 but over time it ends up being
assume it has to do with absolute/relative cell references but I’ve tried
locking some cells and it seems to have no effect. Basically, I want rules to
apply to all cells in the cell range permanently, regardless of the data.
I’m also wondering if it has to do with copying/pasting/deleting of cells,
since I’ve learned that apparently, the best way to swap the data on row A and
row B while preserving formatting (like centering text for an entire column) is
to copy row A to an empty row C, copy row B to row A, copy row C to B, and
delete row C (would love to know a better way to shift cells around without
messing up formatting. Cutting instead of copying causes the cell it was cut
from to lose is formatting).