Thread: Formatting a cell to show something different the entered value
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TTAmo TTAmo is offline
external usenet poster
  
Posts: 3
Default Formatting a cell to show something different the entered value
Can someone please help?

I'd like to see an "H" in a cell when I enter a 3; "M" for 2; "L" for 1.
I've tried custome formatting, but haven't figured it out.

Any suggestions?

Thanks.
Reply With QuoteReply With Quote