What formula will tell you that a specific cell contains a specific text? Well, you need to make use of FIND function in order to search for some particluar text.
FIND (text, cell)