contain option in conditoinal formating

[Vijay]

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

 

[Kassie]

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

 

[Jacob Skaria]

From menu

Format>Conditional 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