Previous Topic Next Topic

Conditional format

Solved/Closed
boon1d Posts 2 Registration date Wednesday May 22, 2013 Status Member Last seen May 27, 2013 - May 22, 2013 at 05:28 AM
 boon1d - May 27, 2013 at 04:03 AM
Dear reader,

I was wondering if there is a possibility to specify the number of charakters in a conditional format in Excel.
Example. NL08569638 I want to have conditional format to control if there are (2 letters) and (8 figures)

Is that a possibility?

kind regards
Related:

1 response

Answer 1 / 1
TrowaD Posts 2921 Registration date Sunday September 12, 2010 Status Moderator Last seen December 27, 2022 552
May 23, 2013 at 11:23 AM
Hi Boon1d,

I think I covered all bases with this formula but do test it out for yourself by changing the cell content:

=IF(AND(IF(ISERROR(LEFT(A1,2)*2),TRUE,FALSE)=TRUE,IF(ISERROR(RIGHT(LEFT(A1,2),1)*2),TRUE,FALSE)=TRUE,IF(ISERROR(RIGHT(A1,8)*2),FALSE,TRUE)=TRUE,IF(LEN(A1)=10,TRUE,FALSE)=TRUE),TRUE,FALSE)

Best regards,
Trowa
1
boon1d
May 27, 2013 at 04:03 AM
Dear Trowa,

many thanks for the help, it helped a lot!

kind regards,
Boon
0

Similar discussions

How to use conditional format based on text?
Leanne99 -
Mooseman -

26 responses
Highlight cell if another cell contains specific text
Abbi -
vcoolio -

1 response
Unsupported signal. Please check device output
S.Agnew -
Yaya68 -

14 responses
Highlight cell if another cell contains any text
LvH -
LvH -

4 responses