I have a problem below that need to use "len" function.

How do you highlight all cells that have a two-letter string in yellow,
for example, AB, BB with yellow color by using conditional formatting
(Under Format menu).

ABC
BCA
AB
AA
BB
ACB
ABC
ABC
BA
CBA

Thanks


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