Star Rating Number Format
It’s Wednesday night. That means I’m drinking Tangueray and reviewing football games (for entertainment purposes only). I like to rate games on a three-star system. Three stars means refinance the house and fly to Vegas. Two stars means I really like a team. And one star means I’d have as much luck flipping a coin. Zero stars means Purdue is playing (why Purdue wins when they should lose and loses when they win is beyond me).
Instead of putting a 1, 2, or 3 next to the team, I want actual stars.
To get that look: left align, set font to Wingdings, and use this custom number format:
[<2]"«";[<3]"««";"«««";
And to get those double chevrons (or whatever they are), hold down the Alt key and type 0171 on the numeric keypad. Now type a 1, 2, or 3 in the cell and your in like Roger Ebert.
P.S. I can never remember how to do that conditional number format thing, so I always go to PeltierTech.com to re-learn it.
Gary OBrien:
I’ll second the Tanqueray, although it doesn’t have to be Wednesday
Of course, in Excel 2007 there is a much easier way to do this with the conditional formatting icon sets. Using the pre-defined sets gives you the ability to quickly create dashboards with traffic light signals, increasing bar graphs, etc. using percentages or numbers. This is probably one of my favorite enhancements in this version.
2 October 2008, 4:42 amHui...:
of course depending on the future use for the cells with the stars you could keep it simple and just type “Shift 8″ as many times as was required.
5 October 2008, 6:23 pmStan Brown:
This was a great entry, and worth its weight in gold for he reference to Peltier. I never seem to be able to find the information about number formats in Excel help, so this is a terrific reference.
13 October 2008, 11:00 am