Message Box if cells contain criteria

[thedeadzeds]

Hi Guys,

Is it possible to do the following:

If A3:A5 contains X then message box shows hit
If K2:N2 contains X then message box shows hit
If K10:K14 contains X then message box shows hit
Else show Miss

Thanks

 

[thedeadzeds]

Amazing thank you very much for the help