Check column for yesterday's date

hi all,
im trying to write an if stament to check for yest date in coulmn AD. what i wrote so far it not working properly. any help would be great thanks!!!

Please Login or Register  to view this content.

This will work.

Please Login or Register  to view this content.

works great but is it possbile to give me msg once and not for each cell it checks in that column. i just want to know if the date is in the column at all and if it is jsut send me a msg once whether it is or isn't