Changing a value to a letter
 

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

Changing a value to a letter
 

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

"Lisa" wrote:

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

Changing a value to a letter
 

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




"Lisa" wrote in message
...
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!!!!!!

Changing a value to a letter
 

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


"Lisa" wrote in message
...
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!!!!!!