I have a column with various text entries. I have created a conditional formatting rule for each type of entry but the formatting can be grouped together, so I would like a Conditional Formatting rule that says:

If string contains "foo" or "bar" then colour red
If string does not contain "yibble" or "wibble" then make bold
etc.

Any idea how I can do this rather thasn having to manage over 30 rules with each one looking for a single text entry type.

Thanks

Darius

---
frmsrcurl: http://msgroups.net/microsoft.public...heet.functions