Conditional formatting with LEN between values

[Legs]

I am trying to use conditional formatting to highlight cells with have a text length between 1 and 20 characters however I can only get the LEN function to count less or greater than. Is it possible to use Len to count between 1 and 20?

Thanks

[Pete_UK]

In the CF dialogue you should select Use A Formula... , then put this formula in the dialogue box:

=AND(LEN(A1)>0,LEN(A1)<=20)

Obviously, you should change A1 to the appropriate cell reference of the active cell (assuming you have selected the range of cells beforehand).

Hope this helps.

Pete

[Phuocam]

Try ...
=AND(LEN(A1)>0,LEN(A1)<21)

[Tony Valko]

Here's another one...

=AND(LEN(A1),LEN(A1)<21)