Conditional Formatting

  • Thread starter Thread starter Guest
  • Start date Start date
The problem with using conditional formatting in a pivot table is that
if the fields are rearranged, the conditional formatting doesn't move
with them. It stays on the cells that were originally formatted.
 
Hi ####-

As Debra says, the conditional formatting applied to sheet cells that PT's
are base on does not carry over to the PT. (Most applied to the detail cells
would probably not be appropriate anyway.)

To go a little farther, though, you can select cells in the PT, itself, and
apply Conditional Formatting to them.

Good Luck |:>)
 
You must log in or register to reply here.

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

conditional formula 1
Conditional Formating 5
Conditional Format - Pivot Table 1
Can you set conditional formatting in pivot table? 2
Pivot Table/Conditional Formatting Guru Help 2
Conditional Formatting in a pivot table 2
Pivot table 7
COPYING CONDITIONAL FORMATTING WHEN COPYING CELLS OVER 2

Back
Top