Can I accomplish this with Conditional Formatting or another way

Closed
SD - Jan 31, 2015 at 09:55 AM
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 - Feb 2, 2015 at 11:01 AM
Hello,

I have two worksheets. I would like to enter values in a column of sheet 1. When any of those values match a value in a table on sheet 2, the cell on sheet 1 should assume the fill color of the matching cell value's fill color from the table on sheet 2.

Please advise if I can accomplish this with conditional formatting as well as the steps. If there is another way, VBA or otherwise, to accomplish this please advise as well.

Thank you in advance.

1 response

TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
Feb 2, 2015 at 11:01 AM
Hi SD,

Conditional format can't copy the format of other cells.

Can you specify in which columns or rows you enter your data on sheet 1 and also the table location on sheet 2 to provide you with a suitable code?

Best regards,
Trowa
0