Hi,

i've a problem about conditional formatting on a pivot table:

I've following pivot table:

The second and the third row of Quantità Lorda are blank because there aren't values in DB (All dimensions are in full outer join).

On the column i've applied Conditional Formatting : WHEN Color = 'AZZURRO' Background green.

The editor fills only first cell, the only one with a value in DB, conditional formatting doesn't work for the whole column. How can I do ?

I've tried to apply ifnull function to Quantità Lorda column:

IFNULL(Quantità Lorda, 0), but as you can see blank values aren't replaced by 0. Maybe the real value isn't NULL?

I'm so frustrated.

Regards

Giancarlo