2

I use this function

=LEN(P3:P)<6 

in order to highlight all the entries with less than 6 digits (6 is minimum)

However, all the blank cells also highlight red. What function do I have to do in order to not affect blank cells? I can base it on if Column E is filled (since that should always have info). But I don't know how to do that

1

You shall use this custom formula:

=(LEN(P3)<6)*(P3<>"")

1
  • 1
    thank you that worked perfectly! – Yosief Ellaham Jul 23 '19 at 0:17

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.