View Full Version : Conditional Formatting static “Applies To:” field

11-07-2016, 05:54 PM
Is there a way of making the “Applies To:” field in Conditional Formatting static? Meaning, if a user moves the contents of the cell to another cell the Applies To field stays the same. I have been looking at websites and they mention Name Ranges but I have been unable to get it to work.

Any ideas?