Pivot Table Conditioning Changes when expand/collapse

[dmj120]

First, copying with the Xl2BB doesn't look right. But more to the point, I set three conditional formattings, but when any item is collapsed or expanded, the "applies to" range changes.

Is it possible to have the pivot table keep formatting regardless of collapsing?

VSC Strategy Master Workbook.xlsx
	B
3	EOL
4	FDC
5	Internal Reserve
6	Needs Review
7	PM Only Contract
8	Remote Monitoring
9	Risk Avoidance
10	T&M
11	Self Perform
12
13
14
15
16
Pivot

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:E2,B21:E25000,B3:C20	Expression	="$B2=""Self Perform"""	text	NO

VSC Strategy Master Workbook.xlsx
	B
18	MSA
Pivot

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
B2:E2,B21:E25000,B3:C20	Expression	="$B2=""Self Perform"""	text	NO

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel Forum
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[dmj120]

Sorry, I'll keep this in mind. Didn't mean to offend or faux pa.