Forum Discussion

i.chevereau's avatar
i.chevereau
Copper Contributor
Oct 05, 2018
Solved

fill color in cells that contain some text

Hello. I am a total newbie on Excel (and a bit computer-challenged  at that ). I have tried in vain to find the rule that would fill the cells of a specific column with a green highlight color if and only if they contain some text, leaving the cells in white if they are empty. I have tried the rule IF+TEXT+ green , but the whole column turned green. I would appreciate any clear advice. I must also specify that I know the basic French computing lexicon , but this is also my first try at an expert forum in English. Merci !

  • That's a bit different way. Steps are

    1) Select your range, Conditional formatting -> New rule

    2) Here select Use a formula...

    and here type your formula and apply desired format

    Sorry, have no idea how above will be in French

9 Replies

  • Jan Andreasen's avatar
    Jan Andreasen
    Copper Contributor

    Hi

     

    You are using french version of Excel, is that right?

     

    Excel have a function called "conditional formatting" where you enter the condition (Text = "This") and chose the formatting.

     

    According to Google, it should be called "formatage conditionnel"

     

    You can see a screenshot here:

     

     

    I hope this helps you :)

    • i.chevereau's avatar
      i.chevereau
      Copper Contributor

      thank you for your kind suggestion. That much how know how to do, although I use the "equal to" to get the cells to fill in with the chosen color. In that case, I thought the ESTTEXTE would have been enough. But it seems not.

  • Philip West's avatar
    Philip West
    Steel Contributor

    hia

    there is a formula ISTEXT() that will return true/false if you give it something to check..

     

    My trusty online language converter tells me that in French excel this is: =ESTTEXTE(A1)

     

    You should be able to use that in a conditional format.

    • i.chevereau's avatar
      i.chevereau
      Copper Contributor

      Thank you, I have just tried that...and it does the exact opposite of what I want. I.e the cells are white when I type anything, and the empty ones are the green I chose. How can I get the cells to remain white unless I type some text, then they turn green ? I can see you put me mor eor less on the right track, so thanlk you anyway.

Resources