Ask Your Question

Conditional format colour change if cell contains any characters at all? [closed]

asked 2019-08-15 06:37:24 +0200

appreciatethehelp gravatar image

updated 2020-07-21 20:35:30 +0200

Alex Kemp gravatar image

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.


edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by appreciatethehelp
close date 2019-08-15 20:27:52.847742


Do you mean "Not Empty" condition?

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-15 11:16:26 +0200 )edit

@ 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?

appreciatethehelp gravatar imageappreciatethehelp ( 2019-08-15 11:54:24 +0200 )edit

Cell value -> not equal to -> ""

Mike Kaganski gravatar imageMike Kaganski ( 2019-08-15 12:23:11 +0200 )edit

Thank you!

appreciatethehelp gravatar imageappreciatethehelp ( 2019-08-15 20:27:35 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2019-08-15 13:14:45 +0200

@appreciatethehelp, see picture

image description


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 Descrição da imagem to the left of the answer, to finish the question.

edit flag offensive delete link more

answered 2019-08-15 11:14:57 +0200

m.a.riosv gravatar image

Put it inside quotes like you must do in a formula: "H"

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2019-08-15 06:37:24 +0200

Seen: 100 times

Last updated: Aug 15 '19