Forum Discussion

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

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 do it with one using conditional formatting, but no more than one.  Any help would be appreciated.

Thank you,

Rick 

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

Resources