From menu

FormatConditional Formatting
In condition1 select 'Formula Is'

Enter
=COUNTIF(A1,"*VIJAY*")

and select a color

This will highlight the cell containing a word 'vijay' anywhere in the cell

If this post helps click Yes
---------------
Jacob Skaria


"Vijay" wrote:

Hi,

How to set contain option in Conditional formating. I want to formate the
cell which contain a specific word not a complete cell.

Please tell me how to do it.

Regards,
Vijay