SOLVED

Use nested IF-THEN statements to fill cells with different colors

%3CLINGO-SUB%20id%3D%22lingo-sub-2090272%22%20slang%3D%22en-US%22%3EUse%20nested%20IF-THEN%20statements%20to%20fill%20cells%20with%20different%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090272%22%20slang%3D%22en-US%22%3E%3CP%3EI%20need%20a%20formula%20that%20will%20look%20at%20the%20selected%20cells%2C%20and%20depending%20on%20the%20text%20found%2C%20color%20each%20one%20appropriately.%20I%20can%20do%20this%20with%20one%20text%20string%20and%20one%20color%2C%20but%20I%20have%20multiple%20text%20strings%2C%20and%20I'd%20like%20to%20be%20able%20to%20mark%20each%20one%20with%20its%20own%20color.%20Thanks!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2090272%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2090289%22%20slang%3D%22en-US%22%3ERe%3A%20Use%20nested%20IF-THEN%20statements%20to%20fill%20cells%20with%20different%20colors%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2090289%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F940170%22%20target%3D%22_blank%22%3E%40Mark-NY%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20can%20use%20conditional%20formatting.%3C%2FP%3E%0A%3CP%3ECreate%20a%20rule%20for%20each%20string%2Fcolor.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I need a formula that will look at the selected cells, and depending on the text found, color each one appropriately. I can do this with one text string and one color, but I have multiple text strings, and I'd like to be able to mark each one with its own color. Thanks!

2 Replies

@Mark-NY 

You can use conditional formatting.

Create a rule for each string/color.

Best Response confirmed by Mark-NY (New Contributor)
Solution
Of course! I was so stuck on if-then-else, I didn't think of that. Thanks very much!