SOLVED

Conditionally modify text color

Copper 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
best response confirmed by Rick.Lizotte (Copper Contributor)
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

1 best response

Accepted Solutions
best response confirmed by Rick.Lizotte (Copper Contributor)
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

View solution in original post