Excel 2003: Conditional Formatting: Cell Contains word

[JeffNolan1900]

I have a bunch of cells containing the word: IFS
Example Cells:
LP-XXXXX-01 IFS
LP-XXXXX-02 IFS
PP-XXXXX-03 IFS
PP-XXXXX-04 IFS
PP-XXXXX-03
PP-XXXXX-01

How do I get conditional formatting to hilite cells that contain the word "IFS" when everything else in the cell may be different.

I have tried greater than, equal to...basically all of the general ones, and some formula's, and have search google, I can not seem to find anything that answers my questions.

Thanks,
Jeff

 

[SkipVought]

Hi.
[tt]
=FIND("IFS",A1)>0
[/tt]
where a1 is assumed to be the frist cell in the range.

Skip,

_[red][/red]

 

[JeffNolan1900]

Ok. I got it to work, thanks.
What I had to do was make B3 the active cell.
(B3 is the first cell with Data)
Then I had to hit Ctrl+A (Select All)
Then open up conditional Formatting and put in the formula:
=FIND("IFS",C3)>0

Thanks so much for the quick response.
Jeff

 

[SkipVought]

Hmmmmmmmm????

If B3 is the first cell with this data, and I assume that this data is ONLY in column B, then you hit Ctr+A to select ALL data, then you opened CF, then your formula does NOT make sense...
[tt]
=FIND("IFS",$B1)>0
[/tt]


Skip,

_[red][/red]