Conditional format
Solved/Closed
boon1d
boon1d - May 27, 2013 at 04:03 AM
- Posts
- 2
- Registration date
- Wednesday May 22, 2013
- Status
- Member
- Last seen
- May 27, 2013
boon1d - May 27, 2013 at 04:03 AM
Related:
- Conditional format
- Excel conditional formatting if another cell contains specific text ✓ - Forum - Excel
- Conditional formatting excel if another cell contains text ✓ - Forum - Excel
- Conditional formatting if another cell is blank - Forum - Excel
- If cell contains date then conditional format - Guide
- Excel conditional formatting 5 color scale ✓ - Forum - Excel
1 reply
TrowaD
May 23, 2013 at 11:23 AM
- Posts
- 2886
- Registration date
- Sunday September 12, 2010
- Status
- Moderator
- Last seen
- June 27, 2022
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