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?
