I want to add a conditional format so that certain cells turn a certain colour when one character or more of any kind is entered into them.
I have created my colour Condition, now how do I set it up? I have entered Cell Value Is > Contains but am unsure how to specify “any character” in the Contains box.
Cheers.
Do you mean “Not Empty” condition?
@ Mike Kaganski Sounds right; if any characters of any kind are entered in the cell, I’d like the format to change to the colour specified in the Style. I tried entering “Not Empty” under Cell Value is > Contains but no success; how should I go about this?
Cell value → not equal to → “”
Thank you!
Put it inside quotes like you must do in a formula: “H”
@appreciatethehelp, see picture
ATTENTION: If you would like to give more details to your question, use edit in question or add a comment below. Thank you.
If the answer met your need, please click on the ball 
to the left of the answer, to finish the question.
