Can I accomplish this with Conditional Formatting or another way

Closed
SD - 31 Jan 2015 à 09:55
TrowaD Posts 2921 Registration date Sunday 12 September 2010 Status Contributor Last seen 27 December 2022 - 2 Feb 2015 à 11:01
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 12 September 2010 Status Contributor Last seen 27 December 2022 555
2 Feb 2015 à 11:01
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