Current cell in a Pivot table

[GabrielOtet]

Dear all,

I have to color the cells in a Pivot table if a condition is in place.

The tricky part is that I want to collor every cell in a different collor (based on the value which is inside).

I know how to color it based on the Row or Collumn condition but it will color the complete line and not only a cell.

Do you know if something like this is possible?

I'm thinking of something that enables me to operate into the current cell, like:

If (current cell value > something, rgb(...), rgb (...)) - unfortunately I'm not able to do it

[skamath1 · Accepted solution]

Put the same expression as that on the measures in the if condition.
For example, if your measure expression is Sum(Sales) then in the background color expression enter the following.

IF ( Sum(Sales) > 5000000 ,LightGreen(),LightBlue())

You can add nested IF function for different color conditions.

[GabrielOtet]

It worked perfectly!

Many thanks for the help.