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.
excel_user123456 wrote:
Is conditional formatting handled diffrently in a pivot table?
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html