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
boon1d - May 27, 2013 at 04:03 AM
Related:
- Conditional format
- Excel date format dd.mm.yyyy - Guide
- Format factory - Download - Other
- Samsung format code - Guide
- How to format windows 7 - Guide
- Jpg format download - Download - Image converters
1 reply
TrowaD
Posts
2921
Registration date
Sunday September 12, 2010
Status
Moderator
Last seen
January 16, 2023
547
May 23, 2013 at 11:23 AM
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
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
May 27, 2013 at 04:03 AM
many thanks for the help, it helped a lot!
kind regards,
Boon