Based on the entry in a cell in a column (B), how would a message box appear
based on the entry.

Example:
If B2 = "NY", message box would appear, "Talk to John"
or if B5000 = "NY" same message would appear

Message box should appear for "NY" in the column and not a specific cell.

Thank you in advance