Conditional formatting in a Pivottable that changes with a Slicer

[Rebelexcel]

Hi,

I have this simple but infuriating problem with a pivottable.

I want all negative values (conditional formatting all values less than 0) to be font color red. This works when I apply as usual through a new rule, but every time the pivottable changes (im using a slicer) the conditional formatting disappeares.

Condformatting.JPG

How do I force it to ALWAYS formatt cells B to M (the pivottable range).

Thanks a lot!

/R

[Shareez Saleem]

Instead of selecting the whole table, place your cell on any of the numerical value (Values filed) and do a conditional formatting.
Select the Option# 2 as shown in the picture.Screenshot 2020-10-14 145256.png

[Rebelexcel]

Hi,

I have this simple but infuriating problem with a pivottable.

I want all negative values (conditional formatting all values less than 0) to be font color red. This works when I apply as usual through a new rule, but every time the pivottable changes (im using a slicer) the conditional formatting disappeares.

Attachment 699563

How do I force it to ALWAYS formatt cells B to M (the pivottable range).

Thanks a lot!

/R

Works great. Solution verified!