Forum Discussion

Matthew Bennett's avatar
Matthew Bennett
Copper Contributor
Jun 13, 2018

Enter any text cell changes colour?

Hi

 

I am trying to set up a conditional formatting rule so that when any text is entered into as specific cell, the cell changes to a certain colour. I cannot seem to do this without it being specific text. Is this even possible?

 

Thanks

 

Matt 

excel
  • Hitesh Gaur's avatar
    Hitesh Gaur
    Copper Contributor
    Jun 13, 2018

    Hi,

    Select the cell you want conditional formatting on:

    Select: 1. Conditional Formatting:

    2. Format only cells that contains

    3. Select "No Blank" under Format only cells with

    4. Choose color

    5. OK...

    Please let me know if it works.

    Hitesh Gaur

Resources