I have a pivot table that I am trying to make dynamic with the conditional formatting. Whenever I enter the formatting info it's fine until I start trying to filter items in and out of the table then it gets all jacked. Is there any way keep that formatting dynamic so that then I do this the formatting will stay in place?