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...
Think the best would be for Microsoft to allow you to 'lock range' on a conditional formatting rule.
Been reading several work-arounds that require forever maintenance. Adding the range lock would be a huge help.
It may be possible to set up a table, and then add the formatting to that table, but is extra work and not the simplest approach.