Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!! |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!! |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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!!!!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Changing letter case to user specified. | Excel Discussion (Misc queries) | |||
Changing a letter, to a number??? | Excel Discussion (Misc queries) | |||
Print other worksheet by changing a Letter/# on another page. | Excel Worksheet Functions | |||
Changing text from all caps to first letter cap | Excel Discussion (Misc queries) | |||
Have A Letter Reference A Name For An Intoduction | New Users to Excel |