condition formating word in text cell

I

Ivo Costa

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
 
D

Dave Peterson

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



Ivo said:
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
 
Top