asked on

How to highlight some entries in one Worksheet based on string match value on the other worksheet ?

Hi,

I've got a list of Windows Update entries in one worksheet called "Patches to be applied" and another list of bad patches called "bad patches" worksheet.

So now can someone please assist me how to make the entries in "Patches to be applied" worksheets highlighted in red colur when there is a KB number matched in "bad patches" worksheet ?

See the attached Excel Spreadsheet.

Thanks,
Updates.xlsx

Subodh Tiwari (Neeraj)

Select the range A1:A123 on the sheet Patches to be applied and make a New Rule for Conditional Formatting using the formula given below and set the format as per your choice.
In the attached file, I have set the conditional formatting to highlight the cells with Red Fill and Bold and White Font.

=OR(ISNUMBER(SEARCH('Bad Patches'!$A$1:$A$38,A1)))

See if this helps.
Updates.xlsx

Albert Widjaja

ASKER

SKTNeer,

Thanks for the quick reply.

However, when I added new entry in the last line of 'Bad Patches' worksheet, it didn't highlight the entry in the "Patches to be applied" worksheet ?

ASKER CERTIFIED SOLUTION

Subodh Tiwari (Neeraj)

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Albert Widjaja

ASKER

You are amazing mate !
thanks this is just what I want.

Now I learn something new.

Subodh Tiwari (Neeraj)

You're welcome. Glad I could help. :)