PDA

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



oam
11-07-2016, 05:52 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 and INDIRECT but I have been unable to get it to work.

Any ideas?
Thank you for your help