HELP on conditional formatting

[serene83]

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

 

[Dav]

Use conditional formating, formula is and if the cell is a3
=LEN(A3)=2

Then format as Yellow as a colour

Regards

Dav

 

[Bob Phillips]

Just use CF with Formula Is and a formula of =LEN(A2)=2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

Assuming your data start in cell A2, select range A2:An (as necessary), in
Conditional formatting dialog choose formula as condition and enter this
formula:

=LEN(A2)=2

and set yellow color, then press OK!

Regards,
Stefi


„serene83†ezt írta:

 

[serene83]

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.

 

[Bob Phillips]

No, when you highlight them all, as the first cell is A1, use

=LEN(A1)=2

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

 

[Guest]

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


serene83 skrev: