To set the colour of a cell if say A1 contains the word "look", use Format,
Conditional Formatting, Formula is, and enter
=FIND("look",A1,1)=1. Click on Format, and set the pattern to the colour
of your choice.
--
HTH

Kassie

Replace xxx with hotmail


"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