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