| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting when inserting a row | Excel Worksheet Functions | |||
| Conditional formatting : amount of decimals | Excel Discussion (Misc queries) | |||
| Conditional Formatting Error | Excel Worksheet Functions | |||
| difficulty with conditional formatting | Excel Discussion (Misc queries) | |||
| Conditional formatting not available in Excel | Excel Discussion (Misc queries) | |||
Hybrid Mode
