I'm trying to get different pushpin symbols based on the text content of a spreadsheet cell...for example:
FRUIT
apple = red pin
grape = purple pin
kiwi = green pin
...but I have more than 8 variables...any thoughts?

I'd then like to be able to print a map with only the one color pin...

Thanks in advance!