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.