I have a pivot table that I have created and applied conditional formatting. It begins on row sev and highlights every other row. I apply it and it looks great. Until I click anywhere. When I do that, the formatting is removed from every column except Column A. What is happening? Firstly, I am doing this manually, selecting the range and applying the conditional formatting. So I would like to know why this is happeneing. Secondly, I am going to create macro to get the VBA to do this automatically. Givien this, I would like to know how to select the range dynamically. Meaning, I see the vba where I Select the range manually, but this data can change from day to day and will need to be regenerated. Meaning, how do I dynamically select A7 and go to the last row in my data? Anyhelp with these two would be appreciated.


Thanks