Forum Discussion
fill color in cells that contain some text
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
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 :)
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.
It's enough - attached
Thank you, that is exactly what I am trying to do; I fill the cells one by one because I haven't worked out how the rule must be written exactly. Here is a screenshot of how iam doig it. Could you just tell me the path you are using to get to the result you have shown me, step by step ? Just writing " =ESTTEXTE or =ESTTEXTE(H) hasn't worked so far.
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