I was curious how to do temporarily turn off Conditional Formatting in excel for a subset of my cells and I didn't see an answer so I'll post a solution and see if others have a better solution.
This is what worked for me:
This should work. If you need to unset it... highlight the cells and remove this top 'override' rule or set it to '=FALSE()' (without the apostrophe's) if you think you'll be switching formatting off/on constantly vs just temporarily.