I'm having problem with Conditional formatting in a pivot table.
The pivot is connected to an OLAP db (SSAS).

The values looks like this.
VALUE 45,00 28,20 47,25
Accepted VALUE 60,00 55,00 40,00
Critical VALUE 39,00 30,00 25,00

I'd like to set the conditional formatting on the VALUE.
Using "traffic lights" it should be green if it is larger than (=) the
Accepted VALUE, yellow if it is larger than (=) the critical and red if
lower.

I have tried with an icon set using the formulas
=INDIRECT("R[+1]C";FALSE)
and
=INDIRECT("R[+2]C";FALSE)
(setting the types to numbers) to get the two values below the VALUE in the
pivot.

This gives me the strangest bug.
The icon rule is formatted based on which cell I select, inside or outside
the pivot table (?).
If I select an empty cell outside the pivot they all turn green but if I
just enter random numbers outside the pivot and select the cell above or if I
select a cell inside the pivot with numbers in the cells below, the rule is
set according to the values.

Can anyone help me with this? Macro or formula, all tips are appriciated.
Thanks,
Mats M

PS. If it is to any help; The VALUE is a calculated member and the limits
are measures in the cube.