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