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.
.Range("A7:A" & .Range("A65536").End(xlUp).Row).FormatConditions.AddColorScale ColorScaleType:=3
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