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
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.
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.
