Thanks for the update dude!
I tried having a go myself at helping make these checklists a lot easier to generate, like with your conditional formatting so far -to make a "template" of sorts, would future-proof your work and keep these the preferred checklists by the community I think!
I can see what you were trying to do with column C, but that it doesn't work (or at least doesn't seem to). I've come up with this formula that should fix it, paste into B3 and then repeat down:
=IF(C3="c","●",IF(C3="u","♦",IF(C3="r","★",IF(C3="h","★H",IF(C3="ex","★EX",IF(C3="fa","★FA",IF(C3="sc","★H","?")))))))
That should contain the circle, diamond and star symbols already - the font is Arial Unicode MS. If it isn't displaying properly on here you'll have to add them again in word/something using Insert Symbol. They are in the "Miscellaneous symbols" section, a little spread apart but you should find them (go straight to that section if you can, lotta characters!).
Hope that helps, I'll see if I can't help out with some of the promo listings in the meantime. Don't want to push in though dude, you put a lot of work into this and it's yours - tell me to get lost if you want!:biggrin:
Cheers mate!
---------- Post added 02/03/2013 at 10:30 PM ----------
Even better - a hollow star for super-rares
=IF(C3="c","●",IF(C3="u","♦",IF(C3="r","★",IF(C3="h","★H",IF(C3="ex","☆EX",IF(C3="fa","☆FA",IF(C3="sc","☆H","?")))))))
---------- Post added 02/03/2013 at 10:33 PM ----------
OK weird, it added a space in the last IF, "s c". Take that out and its good - trying again:
=IF(C3="c","●",IF(C3="u","♦",IF(C3="r","★",IF(C3="h","★H",IF(C3="ex","☆EX",IF(C3="fa","☆FA",IF(C3="sc","☆H","?")))))))