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.
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.
Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
Sam Capricci
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks