If the first cell is A1 "ABC". Type =LEN(A1)=2 when the whole daterange is
selected.
It works like a charm.


serene83 skrev:


I have try it but unable to get the desirable ans.

ABC
BCA
AB
AA
BB
ACB
ABC
ABC
BA
CBA

I highlight the whole data and go to conditional formatting and use
"formula is" =LEN(A3)=2 since A3 is AB. But the answer i got are only
BCA and AB is being highlighted, not the all the two-letter string
like BB AA. Please advise. Thanks.


--
serene83
------------------------------------------------------------------------
serene83's Profile: http://www.excelforum.com/member.php...o&userid=35778
View this thread: http://www.excelforum.com/showthread...hreadid=555902