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, 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.
You are welcome!