I've searched high & low on this one & the general consesus I've found
is that it simply can't be done?... Has anyone any bright idea's on the
following?

I've assigned star symbols to the grades as follows:

A: ***** (5 green stars)
B: ***** (4 green stars, 1 white)
C: ***** (3 green stars, 2 white)
D: ***** (2 green stars, 3 white)
E: ***** (1 green star, 4 white)
F: ***** (5 white stars)

I want to use vlookups to return the star values in the corresponding
cells for each grade.

Eg. A grade to show ***** etc.

The formating of the star colour is the important thing here --
Apparently there's no way of copying formats with formula's in excel??

Has anyone any bright idea's how you might get around this?

Is it possible to automatically replace characters with autosymbols?

Conditional formating is no use as there's only 3 conditions & you
would have to format the whole cell regardless instead of just
particular characters in the cell.

Any help/suggestions would be much appreciated.

Thanks!!


--
loscherland
------------------------------------------------------------------------
loscherland's Profile: http://www.excelforum.com/member.php...fo&userid=6709
View this thread: http://www.excelforum.com/showthread...hreadid=534605