Conditonal Format Based On Multiple Strings

[drew27c]

I want to format cells as different colours based on lists of strings. For example:


Format cell in MyRange as red if value equals String1 or String2 or String3


Format cell in MyRange as blue if value equals String3 or String4 or String5


Format cell in MyRange as green if value equals String6 or String7 or String8

Currently in my drop down list of strings I am appending a prefix and using that as my condition. I'd like to remove the prefix and use just the raw unique strings.

 

[Fluff]

You could use something like
=OR(A1="String1", A1="String2", A1="String3")
Where A1 is the top left cell of the applies to range

 

[drew27c]

Hey that works great. Thanks

Now the follow up question. Each condition has about 200 strings.

Is there a quick and dirty way to make this formula? Concat is proving difficult.

 

[Fluff]

If you have a separate list of the strings for each condition you could use the MATCH function