Hey guys, I was wondering if you could help an excel novice. What i am trying to do is to have a drop down box that deals solely in colour. It would have 3 different colours on it but i can't figure out how to do it. If anyone can shed some light, it would be greatly appreciated
Do you want to change the color of certain cells? If that's what you're after... View>Toolbars>Formatting Fill color is the tipping paint can. You get more than three.
Unless you're referring to something else, Gregg2 is right. One for Fill Colors: ...and one for Font Colors: