Excel 2007 Conditional Formatting

[TomLon]

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


Thank

 

[GS]

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