Forum Discussion

Manishdewani's avatar
Manishdewani
Copper Contributor
Oct 13, 2021

Condition formatting of Cell Based on Multiple Slicers

Hi All,

 

I am searching for a solution to do conditional formatting of cell based on combination of 3 slicers

Sharing my Excel which contains Report & Benchmark Sheet. Report Sheet Contains 3 Slicers.

 

Center Name..... Turnover...... Industry Segment

 

And Bench Mark sheet have Benchmark %age as per Turnover & Industry Segment

 

 

 

 

 

excel
Formulas and Functions

2 Replies

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 14, 2021

    Manishdewani It looks like your attachment contains sensitive data like people's names, I advise you to remove the attachment and only post anonymized copies.

  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Oct 14, 2021
    Are you sure this is the right file? There are no slicers on any sheet.

Resources