Forum Discussion

CharlineGomez's avatar
CharlineGomez
Copper Contributor
Sep 21, 2022

Conditional formatting within fields pivot table

Good morning everyone,    I am currently stuck on something that I am not even sure is doable...   I would like to get to highlight values within the pivot table depending on fields, my table is ...
excel
Formulas and Functions
CharlineGomez's avatar
CharlineGomez
Copper Contributor
Sep 21, 2022

HansVogelaar 

I'm very sorry, it says I can load files or link... I don't know what's happening. The best I can do for know is this ! 

 

This is what the TCD looks like and this is below the raw data! Hope it can helps further

 

Row Labels Count of forecast
Customer 1 
Exports Americas11
Rest of the world

2

Customer 2

 

Exports Americas

11

Rest of the world

2

 

 

 

 

 

 

 

Account NameYearScopeTrade OrionW39W40W41W42W43W44W45W46W47W48W49W50W51W52forecast check
Customer 1Current YearRest of the worldWORLDWIDE--------------EMPTY
Customer 1Current YearExports AmericasUS-----------

-

 

 

 

 

--EMPTY
Customer 1Current YearExports AmericasCANADA--------------EMPTY
Customer 1Current YearExports AmericasMEXICO--------------EMPTY
Customer 1Current YearExports AmericasBRAZIL--------------EMPTY
Customer 1Current YearExports AmericasARGENTINA--------------EMPTY
Customer 1Current YearExports AmericasCHILE250190190200200225225230235235235235235230UPDATED
Customer 1Last YearRest of the worldWORLDWIDE--------------EMPTY
Customer 1Last YearExports AmericasUS--------------EMPTY
Customer 1Last YearExports AmericasCANADA--------------EMPTY
Customer 1Last YearExports AmericasMEXICO--------------EMPTY
Customer 1Last YearExports AmericasBRAZIL--------------EMPTY
Customer 1Last YearExports AmericasARGENTINA--------------EMPTY
Customer 1Last YearExports AmericasCHILE--------------EMPTY
Customer 2Current YearRest of the worldWORLDWIDE--------------EMPTY
Customer 2Current YearExports AmericasUS--------------EMPTY
Customer 2Current YearExports AmericasCANADA--------------EMPTY
Customer 2Current YearExports AmericasMEXICO--------------EMPTY
Customer 2Current YearExports AmericasBRAZIL--------------EMPTY
Customer 2Current YearExports AmericasARGENTINA--------------EMPTY
Customer 2Current YearExports AmericasCHILE36003600360034003400340034003400340034003400340034003400UPDATED
Customer 2Last YearRest of the worldWORLDWIDE--------------EMPTY
Customer 2Last YearExports AmericasUS--------------EMPTY
Customer 2Last YearExports AmericasCANADA--------------EMPTY
Customer 2Last YearExports AmericasMEXICO--------------EMPTY
Customer 2Last YearExports AmericasBRAZIL--------------EMPTY
Customer 2Last YearExports AmericasARGENTINA--------------EMPTY
Customer 2Last YearExports AmericasCHILE--------------EMPTY
  • CharlineGomez's avatar
    CharlineGomez
    Copper Contributor
    Sep 22, 2022
    Hi Hans! Thanks a lot for your help although it's a bit more complicated than that as I'd like both to be formatting separately, like each values as to be highlighted separately. I don't know if that is possible !

    Thanks again
      • CharlineGomez's avatar
        CharlineGomez
        Copper Contributor
        Sep 22, 2022
        Hi Hans, I am sorry but I see no difference in this file compared to the previous one ? 🙂

Resources