| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Conditional Format?
Excel2003 ...
Col C ... contains <=5 char text starting with 0 to 9 Col D ... contains <=8 char text starting with 0 to 9 Sometimes ... the next to last char in Col D is a "P" or a "T" ... whenever this occurs the last Char of Col D must match 1st char in Col C ... I would like to conditional format where this does not happen. ie: Col C = 3052 ... Col D = 123456P3 ... = valid value (3) ... no format Col C = 3052 ... Col D = 123456T3 ... = valid value (3) ... no format Col C = 4052 ... Col D = 123456T1 ... = invalid value (4 vs 1) ... format Col C = 4052 ... Col D = 123456P3 ... = invalid value (4 vs 3) ... format Col C = 4052 ... Col D = 123456P4 ... = valid value (4) ... no format Col C = 3317 ... Col D = 3317-123 .... = (non issue ... no "P" or "T") Thanks ... Kha |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format?
Use a formula of
=AND(OR(MID(D1,LEN(D1)-1,1)="P",MID(D1,LEN(D1)-1,1)="T"),RIGHT(D1,1)<LEFT(C1)) in the CF -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ken" wrote in message ... Excel2003 ... Col C ... contains <=5 char text starting with 0 to 9 Col D ... contains <=8 char text starting with 0 to 9 Sometimes ... the next to last char in Col D is a "P" or a "T" ... whenever this occurs the last Char of Col D must match 1st char in Col C ... I would like to conditional format where this does not happen. ie: Col C = 3052 ... Col D = 123456P3 ... = valid value (3) ... no format Col C = 3052 ... Col D = 123456T3 ... = valid value (3) ... no format Col C = 4052 ... Col D = 123456T1 ... = invalid value (4 vs 1) ... format Col C = 4052 ... Col D = 123456P3 ... = invalid value (4 vs 3) ... format Col C = 4052 ... Col D = 123456P4 ... = valid value (4) ... no format Col C = 3317 ... Col D = 3317-123 .... = (non issue ... no "P" or "T") Thanks ... Kha |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Conditional Format?
Awesome ... works great ... Thanks ... Kha
"Bob Phillips" wrote: Use a formula of =AND(OR(MID(D1,LEN(D1)-1,1)="P",MID(D1,LEN(D1)-1,1)="T"),RIGHT(D1,1)<LEFT(C1)) in the CF -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Ken" wrote in message ... Excel2003 ... Col C ... contains <=5 char text starting with 0 to 9 Col D ... contains <=8 char text starting with 0 to 9 Sometimes ... the next to last char in Col D is a "P" or a "T" ... whenever this occurs the last Char of Col D must match 1st char in Col C ... I would like to conditional format where this does not happen. ie: Col C = 3052 ... Col D = 123456P3 ... = valid value (3) ... no format Col C = 3052 ... Col D = 123456T3 ... = valid value (3) ... no format Col C = 4052 ... Col D = 123456T1 ... = invalid value (4 vs 1) ... format Col C = 4052 ... Col D = 123456P3 ... = invalid value (4 vs 3) ... format Col C = 4052 ... Col D = 123456P4 ... = valid value (4) ... no format Col C = 3317 ... Col D = 3317-123 .... = (non issue ... no "P" or "T") Thanks ... Kha |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Format (not color format) | Excel Discussion (Misc queries) | |||
| How to create a conditional format that changes the number format | Excel Discussion (Misc queries) | |||
| Conditional Format - Format Transfer To Chart | Excel Discussion (Misc queries) | |||
| copy conditional format to regular format | Setting up and Configuration of Excel | |||
| copy conditional format as ACTUAL format | Excel Discussion (Misc queries) | |||
Linear Mode
