Conditonal Format Based On Multiple Strings

drew27c

New Member
Joined
Aug 16, 2016
Messages
24
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.
 
Last edited:

Some videos you may like

Excel Facts

What is =ROMAN(40) in Excel?
The Roman numeral for 40 is XL. Bill "MrExcel" Jelen's 40th book was called MrExcel XL.

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,915
Office Version
365
Platform
Windows
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

New Member
Joined
Aug 16, 2016
Messages
24
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

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
40,915
Office Version
365
Platform
Windows
If you have a separate list of the strings for each condition you could use the MATCH function
 

Watch MrExcel Video

Forum statistics

Threads
1,099,505
Messages
5,469,024
Members
406,628
Latest member
jared92

This Week's Hot Topics

Top