Hi,

I have a pivot table which changes in size depending on the selections made
and the dynamic base data that is used.
I want to set conditional formatting on the table, so that if a number in
the table is greater than 90% the background will be green.
How do I make the conditional formatting change in relation to the table?
Its no good for me to set all the cells on the worksheet to have the
formatting because there is other info on it the formatting doesnt apply to.

thanks for any help!

thanks for any help
cheers