CODEWITHSUNDEEP
excel
Max
Max

Reputation: 940

Conditional formatting values with specific character/digit count

I'm using this formula =len(a1)<3 to highlight cell values which have less then 3 characters/digits. How can i do the same task to highlight cells with character count between 3 and 5? Instead of just smaller or bigger than function, i want to use between two numbers? thanks.

Upvotes: 0

Views: 836

Answers (1)

cybernetic.nomad
cybernetic.nomad

Reputation: 6368

For the values the formula should be:

=AND(3<A1,A1<5)

For the character count, it should be

=AND(3<LEN(A1),LEN(A1)<5)

Upvotes: 1

Related Questions