HELP on conditional formatting

  • Thread starter Thread starter serene83
  • Start date Start date
S

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
 
Use conditional formating, formula is and if the cell is a3
=LEN(A3)=2

Then format as Yellow as a colour

Regards

Dav
 
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)
 
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:
 
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.
 
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)
 
If the first cell is A1 "ABC". Type =LEN(A1)=2 when the whole daterange is
selected.
It works like a charm.


serene83 skrev:
 
Back
Top