View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Create Harvey Balls in Excel?

In article ,
Mrebisz3154 wrote:

How would I create Harvey Balls in Excel? (Circles full, half full etc that I
can use in a drop down selection menu)


Using a font that contains these characters, put one character each in a
vertical range of cells (perhaps on another, hidden, worksheet) and name
the range (say, "harvey"). In the cell to contain the dropdown, choose
Data/Validation:

Allow: List
Source: =harvey