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