|
HELP on conditional formatting
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 |
HELP on conditional formatting
Use conditional formating, formula is and if the cell is a3 =LEN(A3)=2 Then format as Yellow as a colour Regards Dav -- Dav ------------------------------------------------------------------------ Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107 View this thread: http://www.excelforum.com/showthread...hreadid=555902 |
HELP on conditional formatting
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) "serene83" wrote in message ... 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 |
HELP on conditional formatting
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 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 |
HELP on conditional formatting
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 |
HELP on conditional formatting
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) "serene83" wrote in message ... 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 |
HELP on conditional formatting
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 |
| All times are GMT +1. The time now is 08:14 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com