Previous Topic Next Topic

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.
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 555
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

Similar discussions

Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Corrupt mpp file, can't open the file now
orrihrigursson -
kedemfriedman -

1 response
Formula for conditional format to color cells
kipp2019 -
TrowaD -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses