Here's one approach: You create a new named range called "ShowFormatting" and in it you put either "Yes" or "No". You then amend the conditional formatting formulas so that they ALSO check whether that cell has "Yes" in it. http://blog.contextures.com/archives...al-formatting/
Bookmarks