missing text or string in neighboring cell.

I have the following data and I would like to be notified or alerted or TRUE when the following occurs across several sheets.

Sheet 1 Sheet 2 Sheet 3

A B A B A B
1 hi yes yellow no house yes
2 bye no blue no apartment yes
3 yes red yes no
4 yes

I would like to search column B to find yes or no and see if there is text in column A, if there is no text beside column B across the 3 sheets I would like to be notified, or TRUE.

I have included an image with different data but the same idea. sample sheet.png

Thanks!!

Please do not upload a picture of your file...rather, upload a sample of your workbook, showing what data you are working with, a few samples of your expected outcome is (manually entered is ok) and how you arrived at that. (exclude sensitive info). Pictures are pretty much impossible to edit, and no-one wants to re-type your data for you Also, not all members can upload picture files (Company firewalls and stuff)