Conditional formatting in pivot tables: compare two rows

[avincent]

I have a pivot table showing KPIs, over several months. For each KPI, there's a 'target' value, and an 'actual' value. I'm trying to set conditional formatting so that if the value for 'actual' >=  value for 'target', the 'actual' cell is coloured green; otherwise, colour it red (see screenshot for a simple mock-up of what I'm trying to achieve - the yellows are a nice-to-have).

To confirm; 'KPI' and 'Category' are row dimensions, 'Month' is a column dimension, and the cell values are the metric.

Is this possible in Looker Studio? It feels like a fairly standard use-case, but I can't work out what combination of conditions I'd need to use when setting up the Conditional Formatting rules.

[avincent]

In case anyone else lands here - I couldn't get this to work, so ended up adapting this solution with a normal table (with all the values as text, one leading space for red cells, two for green 😱). Also needed to cover lots of the table to make it look like a pivot table, so it's full of hacks.

It'd be great if there was a way to do conditional formatting based on formulas / relative references, rather than just on constant values.