condition formating word in text cell

[Guest]

how to change cell color with condition formating witch is conditioning by a
word on a phrase in a cell. when finding a specific word , predetermined by
us, on a phrase in a cell, the condition formating change cell color.

thanks for your time
ivo costa

 

[Dave Peterson]

Formula is:
=countif(a1,"*yourwordhere*")>0

how to change cell color with condition formating witch is conditioning by a
word on a phrase in a cell. when finding a specific word , predetermined by
us, on a phrase in a cell, the condition formating change cell color.

thanks for your time
ivo costa