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
Just use the same conditions that set column B.
You may be able to just edit the range so instead of, say, B1:B10 it says A1:B10 to save you adding new conditions
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks