颜色公式B1如下，具体颜色和对应数字，请自行修改和添加
=CHOOSE(MATCH(MID(A1,10,2),{"01","02","03","04","05","06","07","08","09"},0),"红色","蓝色","白色","橙色","黄色","绿色","紫色","黑色","灰色")
码数公式C1如下
=RIGHT(A1,2)&"码"
截图如下
