Conditional formatting

[Guest]

Can anyone tell me if there is a way to create conditional formatting based
on PART of a cell's contents?

For example, if I have a cell that contains "Harris, Tom– Australia", can I
create conditional formatting that will look for the "australia" part of the
cell, and change font color based on it?

I don't know any VBA, by the way...

 

[Frank Kabel]

Hi
use the following formula in the conditional format dialog
=ISNUMBER(SEARCH("australia",A1))

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag
news:[email protected]...

 

[Alan]

One way,
Use this as a formula in the Conditional Formatting,
=IF(ISERROR(FIND("Australia",A2)),0,1)
You can put 'Australia' in a cell, say A1 and then use
=IF(ISERROR(FIND(A1,A2)),0,1)
Regards

 

[Guest]

I tried it...it didn't work...

Hi
use the following formula in the conditional format dialog
=ISNUMBER(SEARCH("australia",A1))

--
Regards
Frank Kabel
Frankfurt, Germany

im Newsbeitrag

 

[Guest]

It worked! Thanks!!
Now I just have to figure out how do make it do more than three conditions.
I have about 7 that I have to use.

 

[Frank Kabel]

Hi
this formula would work for cell A1. It should format this cell if it
contains the string 'australia'. What have you entered exactly for
which cell