Just to add to Gary''s Student's response.

If you put the number in a separate cell (say A1), you can use a formula like:

=REPT(CHAR(182),A1)
(still formatted with Wingdings)

This actually displays multiple stars.

If you want to format each star (character by character, no half stars), you
can't use a formula and you have to select the characters in the formula bar,
then format|cells and change the font color.



vinodks wrote:

i need in excel cell value change in star rating like windows media player
rating ( like 5 star change the value depent colour changes)

--

Dave Peterson