when i set conditional format in pivottable is working fine (before refresh pivottable) but when i refresh pivottable my conditional format already setting is gone
All the formats in the pivot table range are deleted to apply the pivot table formats, so CF it is not preserved at refreshing the PT. *** This bug has been marked as a duplicate of bug 41645 ***