1

I'm trying to color cells that do not start with a letter; but I'm not sure how to specify a character range in this format.

Cells contents such as:

!this one    <--- formatted
this is fine
@email.com   <--- formatted
 leading space   <--- formatted

Ideally, it would color the cell for any non-letter.

2

Formula

=REGEXMATCH(A1,"^[^a-zA-Z]")

Explanation

Set conditional formatting to use a custom formula. Apply the above formula.

  • The first ^ means start of the string
  • Note that the second ^ is inside of [], this means a logical NOT.
  • The a-zA-Z are a two character ranges, lowercase letters and uppercase letters.

References

  • 1
    I didn't realize there was a Regex function; great, I'll look into that more. Thanks again. – user179561 Dec 19 '16 at 18:38

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.