SOLVED
Home

Conditionally modify text color

%3CLINGO-SUB%20id%3D%22lingo-sub-298596%22%20slang%3D%22en-US%22%3EConditionally%20modify%20text%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298596%22%20slang%3D%22en-US%22%3E%3CP%3EHello%2C%3C%2FP%3E%3CP%3EI'm%20a%20novice%20with%20Excel%20and%20could%20need%20some%20help.%26nbsp%3B%20I'm%20trying%20to%20modify%20text%20depending%20on%20what%20it%20is.%26nbsp%3B%20There%20are%20three%20choices%2C%20W%2C%20L%2C%20D%2C%20that%20go%20into%20a%20row%20for%20the%20results%20of%20a%20game.%26nbsp%3B%20I%20can%20do%20it%20with%20one%20using%20conditional%20formatting%2C%20but%20no%20more%20than%20one.%26nbsp%3B%20Any%20help%20would%20be%20appreciated.%3C%2FP%3E%3CP%3EThank%20you%2C%3C%2FP%3E%3CP%3ERick%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-298596%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-299063%22%20slang%3D%22en-US%22%3ERe%3A%20Conditionally%20modify%20text%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-299063%22%20slang%3D%22en-US%22%3E%3CP%3EThanks%20Damien.%26nbsp%3B%20That%20did%20the%20trick.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERick%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-298630%22%20slang%3D%22en-US%22%3ERe%3A%20Conditionally%20modify%20text%20color%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-298630%22%20slang%3D%22en-US%22%3E%3CP%3EHi%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F251180%22%20target%3D%22_blank%22%3E%40Rick.Lizotte%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESelect%20the%20(same)%20cells%20as%20the%20original%20conditional%20formatting%20you%20have%20applied%20and%20apply%20more%20conditional%20formats%20(e.g.%20using%20%3CSTRONG%3EHighlight%20cell%20rules%20%26gt%3B%20Text%20that%20contains%3C%2FSTRONG%3E).%26nbsp%3BConditional%20formatting%20can%20overlap%20with%20various%20conditions.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EJust%20make%20sure%20to%20change%20the%20format%2Fcolours%20so%20that%20you%20can%20differentiate%20them.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ELet%20me%20know%20how%20you%20go%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3EDamien%3C%2FP%3E%3C%2FLINGO-BODY%3E
Rick.Lizotte
Occasional Contributor

Hello,

I'm a novice with Excel and could need some help.  I'm trying to modify text depending on what it is.  There are three choices, W, L, D, that go into a row for the results of a game.  I can do it with one using conditional formatting, but no more than one.  Any help would be appreciated.

Thank you,

Rick 

2 Replies
Solution

Hi @Rick.Lizotte

 

Select the (same) cells as the original conditional formatting you have applied and apply more conditional formats (e.g. using Highlight cell rules > Text that contains). Conditional formatting can overlap with various conditions. 

 

Just make sure to change the format/colours so that you can differentiate them.

 

Let me know how you go?

 

Cheers

Damien

Thanks Damien.  That did the trick.

 

Rick

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
38 Replies
Extentions Synchronization
Deleted in Discussions on
3 Replies
flashing a white screen while open new tab
Deleted in Discussions on
14 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Security Community Webinars
Valon_Kolica in Security, Privacy & Compliance on
13 Replies