Forum Discussion
i.chevereau
Oct 05, 2018Copper Contributor
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
Sort By
- Jan AndreasenCopper 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.chevereauCopper 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 WestSteel 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.chevereauCopper 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.