Apply three colour gradient on column NEXT to column with values

[JasperD]

Hi guys and gals,

I apply a three-colour gradient conditional formatting to values in column A, ranging from 1 to xx with the following simple line of code.

Please Login or Register  to view this content.

However, if I want the same colour scale in the cells in column B applied, is that possible? Column B doesn't contain values, instead it contains names.
Please let me know the possibilities here, thank you.

Kind regards,

Jasper

[JasperD]

Googling around, I found this is not that easy....
Anyone got any pointers?

[JasperD]

I am still stuck with this one - if I would be able to get the colorindex of the colour that's masking the cell through conditional formatting, I would be very happy already!
Thanks for any help provided!