Conditional Formatting ------- Using Slicer

[PP3321]

When Filter by Month using Slicer,
The conditional formatting only applies to 1st column, and not 2 columns.

Can anyone please shed light on this issue?

I am using following code:

=ISNUMBER(SEARCH("Sunday",$B2))

 

[PP3321]

It looks when I filter by Jan, new selection is created...
=$B$30:$C$121,$B$2:$B$29

 

[NARAYANK991]

Hi ,

Can you upload your workbook ?

Narayan

 

[PP3321]

Hi thanks for your post.
I feel uneasy about sharing my workbook.
Anyway I think I found the answer for this problem.
http://datapigtechnologies.com/blog...for-making-your-pivot-table-formatting-stick/

 

[Deepak]

Have a look...

http://chandoo.org/wp/2016/05/11/apply-conditional-formatting-using-slicers/

 

[PP3321]

Thank you!