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

TomLon was thinking very hard :
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

Just because the display of your data changes, doesn't necessarily mean
the shading will adjust accordingly, as expected. Using VBA will
require resetting the shading in your PV to 'no fill', and then reshade
every other row that is displayed whenever the PV updates with new
data. I don't do much work with pivot tables to be any further help,
but I'm sure someone with experience will ship in at some point.

--
Garry

Free usenet access at http://www.eternal-september.org
Classic VB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion