Format copy upon condition [Closed]

Report
-
Hello,
I have a workbook with two worksheets, one with a legend using 2 columns. Column a for name b for colors.

On
The first worksheet i am referncing the legend names in column a from worksheet 2 and trying to get the format of column b on sheet 2 to fill the respective cells in column b on worksheet 1. Any suggestions?

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!