formula for conditional formating

J

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.
 
R

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.
 
J

jockj215

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

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

edvwvw via OfficeKB.com

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
 
D

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.
Click to expand...
 
Top