Forum Discussion
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 ...
Hi Hans, I am sorry but I see no difference in this file compared to the previous one ? 🙂
I highlighted the value of EMPTY instead of the customer.
If this is not what you want, please explain in detail what you do want.
You originally asked to highlight 12 EMPTY for Exports America; that's what the rule currently does (but since the number is 11, Exports America isn't highlighted). You can easily change the rule to highlight if the number is 14 instead of 12. The formula is now
=OR(AND($A4="Exports Americas",$B4=12),AND($A4="Rest of the world",$B4=2))
If you want 14, change it to
=OR(AND($A4="Exports Americas",$B4=14),AND($A4="Rest of the world",$B4=2))
- Hi Hans, thanks a lot! Now I see the difference!
In fact, I'd like both values to be highlighted "Export Americas" and "Rest of the world" as their values are not connected to one another. What I want to see through this table (as we have here more than 150 customers) is which one as 14 empty for Export Americas on which one as 2 empty for rest of the world (cause those values means we didn't get any profit from them!). I don't know if it's clearer ?:)