Conditional Formatting from one sheet depending on values from another sheet

Question

Conditional Formatting from one sheet depending on values from another sheet

Anonymous

Good Morning!

I have two Worksheets that are as follows:

Worksheet 1: ASSY_MASTER_LIST; Has Numbers in Column C5 thru C49

Worksheet 2: BASE MODEL; Has a lot of different "Part Numbers", throughout two different columns.

I would like to compare the numbers in Column C of the ASSY_MASTER_LIST sheet, to the BASE MODEL sheet, and if the numbers appear from

the ASSY_MASTER_LIST sheet in the BASE MODEL sheet, I would like for them to turn green in the ASSY_MASTER_LIST sheet column.

I have no formula created at this time so this is the beginning of my chaos!!!

Let me know what other info you may need.

Your time and expertise are GREATLY appreciated in advance!

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

2 answers

Answer 1

Select C5:C49 on the ASSY_MASTER_LIST sheet.

C5 should be the active cell in the selection.

On the Home tab of the ribbon, click Conditional Formatting > New Rule...
Select 'Use a formula to determine which cells to format'.
Enter the formula

=ISNUMBER(MATCH(C5, 'BASE MODEL'!$D:$G, 0))

where D:G is a range containing the part numbers.

Click Format...
Activate the Fill tab.
Select green as highlight color.
Click OK, then click OK again.

Answer 2

Anonymous

Hans!

You are definitely an MVP in my book my friend! THIS WORKED PERFECTLY!

Now to become as AWESOME as you are!

Cheers to you my friend!

Cordially and thank you so much for your expertise!

Rich

0 comments

Share via

Conditional Formatting from one sheet depending on values from another sheet

2 answers