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
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
Thank you sooo much Sergei ! It actually worked ! Not in my wildest dreams did I ever imagine I would become a happy member of an Excel community. Thank you everybody for your efforts, and have a great weekend.