How about this? I formatted all your concatenated data cells to text. I also copy and pasted text only all your data because it was looking for a file on your desktop to get data from. So just look at the conditional formatting and replicate on your sheet if you it suits your needs.

Basically, the conditional format equation is:

Of course, this will only work if you only have single digit concatenation. If that assumption is not valid, then we can modify the equation to account for it:

Attached Files

Sample.xlsx (16.1 KB, 8 views)