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.

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

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

"jockj215" wrote:

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.

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!
================================================== ===


"jockj215" wrote in message
...
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.

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

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.

Using conditional format (Excel 2003)

Formula is =Search("WRITE OFF",A1,1) set the pattern as the colour that you
want

right click copy - paste special - formats to the cells that you want
to search

edvwvw



jockj215 wrote:
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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200904/1

And one more...

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



jockj215 wrote:

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.

--

Dave Peterson