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...
Thank you very much for your help Damien,
I'm trying to find a way so that for the conditional formatting when a cells is moved the "Applied to" field of the formatting could be locked or somehow to stop that field from changing. Then it should solve the problem. But so far i can't find any way to stop that field from changing when a cells is moved.
Hello friend
Sorry I can't be of more help. I have done a Google search and there are other forums raging on about the same issue but I haven't seen as yet a solid answer.
Maybe someone else on the forum has a creative answer that will make it easy for you to do what you are requesting?
Good luck and best wishes, Nguyen!
Cheers
Damien
Sorry I can't be of more help. I have done a Google search and there are other forums raging on about the same issue but I haven't seen as yet a solid answer.
Maybe someone else on the forum has a creative answer that will make it easy for you to do what you are requesting?
Good luck and best wishes, Nguyen!
Cheers
Damien