Conditional Formatting Help - Highlighting based on the length of data in the cell

Copper Contributor


I scan four different barcodes into a single column, formatted as text, into a worksheet.
The barcodes can have the following lengths: 7, 10, 12 & 15 characters long. I need to be able to highlight the cells if they contain duplicate values, but only if they have a length of 7 or 12. I also need to allow for a cell to be skipped. I came up with this Conditional Format formula:

But I don't know how to incorporate an additional check for the other condition of the cell length of 12.

Conditional Format Ex.jpg

Thank you for your consideration.


2 Replies
best response confirmed by lw5812 (Copper Contributor)





ahh... I knew it had to be something simple.
Thank you so much!