Hi all, I want to set the formatting of certain cells equal to the formatting of adjacent cells within the same row.

Assume I have data in 2 columns, A1:B10.

Col A is Customer Names, Col B is Customer Rank.

Col B has conditional formatting with a color range based on Customer Rank/cell value.

I need Col A to have the same formatting. Is such a thing even possible? Thank you!!

Untitled.png

http://i.imgur.com/D3xckEX.png