Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lisa
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
sp3cialist
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Peo Sjoblom
 
Posts: n/a
Default 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   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tim C
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Changing letter case to user specified. JoeWood77 Excel Discussion (Misc queries) 9 May 30th 07 05:51 AM
Changing a letter, to a number??? ncrowley Excel Discussion (Misc queries) 2 November 21st 05 04:25 PM
Print other worksheet by changing a Letter/# on another page. Rob Excel Worksheet Functions 1 October 1st 05 06:16 PM
Changing text from all caps to first letter cap Dave Excel Discussion (Misc queries) 2 February 18th 05 12:27 AM
Have A Letter Reference A Name For An Intoduction travelersway New Users to Excel 2 February 16th 05 06:47 PM


All times are GMT +1. The time now is 05:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"