conditional formatting on a PivotTable?

C

confused

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel does not accept text format! 0
Mail Merge - displaying a conditional number of decimals 5
Problem with MS Word paragraph and character styles: format getting messed up 2
Conditional number format of x-axis based on value? 2
Conditional Formatting with VBA 4
VBA - (re-) Set a Table Style 2
Conditional Formatting Pivottables 0
Conditional Formatting help (2003) 1

Top