Consumer Report like symbols

[Lubinski]

Product surveys often used graphic symbols to display the ranking of certain features of a product , similar to the Consumers Report format ( empty circle, 1/2 circle, full circle.)
1) What font contains these symbols?
2) Is there a way to convert a numeric result into one of these symbols ( If >than 80 = ____ (symbol) . THANKS

Rick Lubinski
Silver Lake, Ohio

rick@think-energy.net

 

[PaddyD]

Hi!

One 'general' method:

1) Open the character map
2) Find the symbol you want.
3) Note which font set it was from, & copy / otherwise insert it in the workbook (it won't look the same when you first paste it in)
4) do =code() on the cell with your character. Note the number.
5) write a formula of the form:
=if(yourtest,char(x),otherstuff)
where x is given by the result of step (4)
6) format the cell with the font from step (3).

Bits of this process can be speeded up a little, but it should work.

Paddy

 

[Lubinski]

THANKS I will give it a try

Rick L