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.
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..Range("A7:A" & .Range("A65536").End(xlUp).Row).FormatConditions.AddColorScale ColorScaleType:=3
Please let me know the possibilities here, thank you.
Kind regards,
Jasper
Bookmarks