Forum Discussion
Keeping Conditional Formatting when moving cells
Dear Excel Community,
I would like some help with the following issues.
So i setup a conditional formatting where it would applies to certain cells in a row i.e. C9 to T9
it would highlig...
Dear Damien,
I did try to copy and paste, but the only problem was that when i copy and paste the cells the reference within the formula of those cells change also.
Hi Nguyen
So the cell formulas are not using absolute cell referencing?
Is that something worth pursuing to lock your formula down before moving the cells around?
If you can upload the original sheet, it will give a good idea?
You can also reference this Microsoft article which gives some thought around this.
https://support.office.com/en-us/article/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6
Let me know what you think?
Cheers
Damien
So the cell formulas are not using absolute cell referencing?
Is that something worth pursuing to lock your formula down before moving the cells around?
If you can upload the original sheet, it will give a good idea?
You can also reference this Microsoft article which gives some thought around this.
https://support.office.com/en-us/article/move-or-copy-a-formula-1f5cf825-9b07-41b1-8719-bf88b07450c6
Let me know what you think?
Cheers
Damien