Can I accomplish this with Conditional Formatting or another way

[Closed]
Report
-
Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
-
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 reply

Posts
2805
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
September 14, 2021
481
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