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...
Hi Nguyen
Thanks for the question.
Have you tried copying and pasting the cell you want to move, and then deleting/clearing the original cell you have just copied?
It will retain your conditional formatting and you move that value to another location.
Cheers
Damien
Thanks for the question.
Have you tried copying and pasting the cell you want to move, and then deleting/clearing the original cell you have just copied?
It will retain your conditional formatting and you move that value to another location.
Cheers
Damien
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
DamienDear Damien,
The reason i don't use absolute cell referencing is due to my other worksheet constantly being updated based on market condition. So the reference is sometime change and i need to auto-filled them to make the changes on my worksheet alot faster.
Please see attach Excel for reference
