Using Conditional Formatting to find data from multiple worksheets

[ashleywimberly]

I currently have a workbook with two worksheets inside of it that has some of my clients names in both. Some matching, and some missing. I would like to use conditional formatting (or some other search method) to search "Sheet A" for names not found in "Sheet B" and highlight/format these names back in "Sheet A"

Is this possible?
Thank you in advance*

Ashley Wimberly

 

[Joe4]

Duplicate: http://www.mrexcel.com/forum/excel-...formatting-find-data-multiple-worksheets.html

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rules # 12 here: http://www.mrexcel.com/forum/board-announcements/99490-forum-rules.html).

Also, we recommend that you do NOT post your email in the public posts. Spammers love to search for email addresses to Spam. If you ever have need to share it with anyone, we recommend that you do that in a Private Message.