Copy max value of a row and it's backgroundcolor to a other cell

[Apfel007]

Hi there,

I have a pivot table with 3 data COLUMNS, every row has a backgroundcolor (green, red, orange).

A1(green) | A2(red) | A3(orange)
-------------------------------------------
Q1 | 2 | 10 | 9
...

Now I want extract the max value of a row AND it's backgroundcolor to an other column.

How would you solve this?

My ideas are:
Max() formular but how to combine it with get.Cell ... something like that : GET.CELL(63;MAX(B22:D22))

or have I to solve this with VBA?

What do you think.. I need some help with this.


Cheers Apfel007