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
Best Answer
You shall use this custom formula: