condition formating word in text cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
Click to expand...
 
Back
Top