Excel 2007: Copy the colour of one cell (Conditional Formatting) to another

[ajay_gajree]

Hi all

I have a Pivot Table with one metric in the Sum Area. I have used condition formatting to colour code the table.

Eg Table1

Sum Variable1 Date1 Date2 Date3
Instrument1 [Green][Green][Red]
Instrument2 [Green][Amber][Green]
Instrument3 [Amber][Green][Green]

Eg Table2

Sum Variable2 Date1 Date2 Date3
Instrument1 [Green][Green][Red]
Instrument2 [Green][Amber][Green]
Instrument3 [Amber][Green][Green]

If I Put a Copy of Table2 under the Table1 (Values only from the Pivot Table), I want to tranfer the colours from Table1 to Table2.

If I use the Format Painter, this copies the conditional formatting, which is not what I want.

Any ideas on how to resolve this bar colouring manually?

Thanks and regards!