so you mean =IF(MID(A1,2,1)="2","RED",IF(MID(A1,2,1)="1","blue","")) and you'll have to populate the rest using the same sequence. unless you are referring to conditional formatting.