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