Excel 2010 Apply conditional formatting to another cell

Excel 2010 Apply conditional formatting to another cell

In Excel 2010, I have 3 columns in a sheet called FX as follows:
A B C
01-May 1.18910 €6,569.78
05-May 1.18725 €6,559.56
06-May 1.18853 €6,566.63
08-May 1.18138 €6,527.12
11-May 1.18303 €6,536.24
22-May 1.17108 €6,470.22
25-May 1.16952 €6,461.60
Conditional formatting has been applied to column B using one of the color
scales rules.
On another sheet, I am getting the last value in the column and inserting
it into another cell. This effectively shows "the most up to date value".
=INDEX(FX!B:B, COUNTA(FX!B:B), 1)
What I want to do is to also copy the format of that cell - i.e. the
background color assigned to it by the color scale. How can I achieve
this?