formula for conditional formating

[jockj215]

Hi'
I have a spreadsheet (excel 2003) with data from a data base in one of the
cells is text which is free typed in the data base and I want to find the
words "WRITE OFF" within the text string and color the cell. Can anyone give
me a formula that will do this please.

 

[RagDyeR]

Try this:

=ISNUMBER(SEARCH("write off",A1))

with A1 selected and with A1 the cell which contains the data.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================


Hi'
I have a spreadsheet (excel 2003) with data from a data base in one of the
cells is text which is free typed in the data base and I want to find the
words "WRITE OFF" within the text string and color the cell. Can anyone give
me a formula that will do this please.

 

[jockj215]

Done it
=NOT(ISERROR(SEARCH("WRITE OFF",$I2)))

Thanks to all who looked, hope someone will find this useful.

 

[Daniel.C]

If case is an issue :
=NOT(ISERR(FIND("WRITE OFF",A1,1)))
HTH
Daniel

 

[Dave Peterson]

And one more...

=countif(a1,"*write off*")>0

Hi'
I have a spreadsheet (excel 2003) with data from a data base in one of the
cells is text which is free typed in the data base and I want to find the
words "WRITE OFF" within the text string and color the cell. Can anyone give
me a formula that will do this please.