Msgbox if certain value exists in range

Hi all,

It isn't probably to difficult, but i'm still a vba noob

In column P of my sheet there are text values. Sometimes, for example the value could contain "test".
If this is the case i would like that cell to be colored red, and also a msgbox that says "Test is found. It occurs amount of times" where it counts the amount of times it occurs also.

Who wants to help me?

Thanks!!!