Applying the same conditonal formatting for multiple text terms?

[SledDawg]

Conditional formatting newbie, so be gentle...


I'd like to add background color and text formatting to terms in a sheet based on occurences of of multiple strings. For example, I'd like the same background color in cells that contain text strings "software OR microsoft OR msdnn OR msdn"


Iknow I could set up a series of individual rules, but is there a way to write a formula to do this? I tried doing =software OR microsoft OR msdn OR msdnn but I get an error message.


Any help appreciated...

 

[Luke M]

Make your list of words somewhere. Lets say in Z1:Z10

Your conditional format rule (for cell A2) then is simply:

=ISNUMBER(MATCH(A2,$Z$1:$Z$10,0))


Formula is checking A2's contents against the list of cells. This setup makes it easy to change the list of words later, if need be.


ALTERNATE:

Tedious, but if you want all the info in the formula, you write something like:

=OR(A2="software",A2="microsoft",A2="msdn",A2="msdnn")