Changing a value to a letter

[Guest]

im trying to make a spread sheet using conditional formattting but instead of
it changing colour or font i would like for it to change to a letter, for
example when it is between 0-50 i would like it to change to a letter a , for
a value between 50-75 i would like it to change to a letter b and 75-100 to
chnage to alettr c

Someone Help Me Please!!!!!!

 

[Guest]

To my knowledge this isn't possible you would probably be better off using
VLookup.

 

[Peo Sjoblom]

Use a help cell, with the number in A1

=LOOKUP(A1,{0;50.1;75.1},{"A";"B";"C"})

otherwise you would need an event macro

--
Regards,

Peo Sjoblom

Portland, Oregon

 

[Tim C]

Lisa,

Instead of conditional formatting, use a custom number format.

Format > Cells > Number > Custom

Use the format:

"a"[<=50];"b"[<=75];"c"[<=100]

Tim C