Changing a value to a letter

L

Lisa

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!!!!!!
 
P

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
 
T

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
 
Top