Highlighting text using conditional formatting

[Greshter]

Hi All

I'm trying to highlight certain text in a list - namely all text that
end with river, stream or creek. I've been trying to use conditional
formatting but for some reason I can't seem to get it to go (I would
have thought * wildcard would have done the trick but no such luck).
Ideally you would have a different colour for rivers, creeks and
streams. The list is like this

Grey River
Brash Creek
Fred Stream
Hell Stream
Roger River
Turd Creek

and so on (about 3000 entries)

Any ideas about how you can do this?

Feedback appreciated.

Thanks
Mike

 

[ScottO]

Try this...
Select the text that you want to apply the Conditional Format to.
Open up the CF dialog box.
Change "Cell Value Is" to "Formula Is"
In the formula box put =FIND("River",A1) , where A1 is the first cell in the
range to be formatted
Apply the format you want
Repeat for conditions 2 & 3.
Rgds,
ScottO

| Hi All
|
| I'm trying to highlight certain text in a list - namely all text that
| end with river, stream or creek. I've been trying to use conditional
| formatting but for some reason I can't seem to get it to go (I would
| have thought * wildcard would have done the trick but no such luck).
| Ideally you would have a different colour for rivers, creeks and
| streams. The list is like this
|
| Grey River
| Brash Creek
| Fred Stream
| Hell Stream
| Roger River
| Turd Creek
|
| and so on (about 3000 entries)
|
| Any ideas about how you can do this?
|
| Feedback appreciated.
|
| Thanks
| Mike
|

 

[cvolkert]

I think you should be able to achieve this by using the 'Formula is'
functionality of conditional formatting along with the 'Right'
function.

Try this - Select Formula is and in the box next to it type
=right(A1,5)="river" and select the corresponding format

Proceed to do the same for Creek in the second condition and then tweak
to =right(A1,6)="stream" and set your third format.

Note that A1 in the formulas above should be the first cell in your
range. It sounds like you are familiar with conditional formatting to
fill in the blanks - if not let me know.

Chad