Forum Discussion

Rick.Lizotte's avatar
Rick.Lizotte
Copper Contributor
Dec 11, 2018
Solved

Conditionally modify text color

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 d...
Excel Online
  • Damien_Rosario's avatar
    Damien_Rosario
    Dec 11, 2018

    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

Damien_Rosario's avatar
Damien_Rosario
Silver Contributor
Dec 11, 2018

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

  • Rick.Lizotte's avatar
    Rick.Lizotte
    Copper Contributor
    Dec 11, 2018

    Thanks Damien.  That did the trick.

     

    Rick

Resources