Anbuselvam K
Member
Can we show any words in a cell with a value. It means if the cell value is 10:00AM behind the time shadow letters should display "Good Morning" in a same cell.
Multiple activity or display in a single cell
- Thread starter Anbuselvam K
- Start date
Anbuselvam K
Member
I just said for example (10:00AM and Good Morning). actually i have some value in a cell, depending upon the value range i need to display different characters.
For Example,
If the cell value 1 to 10, behind the value shadow letters should display some letters if the value 11 to 20 shadow letters may be change from what i'm define.
I think it's like conditional format or If command. but the same cell should display multiple results. can we?
For Example,
If the cell value 1 to 10, behind the value shadow letters should display some letters if the value 11 to 20 shadow letters may be change from what i'm define.
I think it's like conditional format or If command. but the same cell should display multiple results. can we?
SirJB7
Excel Rōnin
Hi, Anbuselvam K!
First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about your question...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Despite of this the custom expression for cell formatting allows you to specify four parts, so if you could handle to manage your requirements within that constraint you might expand Luke M's example and adjust values properly.
Regards!
First of all welcome to Chandoo's website Excel forums. Thank you for your joining us and glad to have you here.
As a starting point I'd recommend you to read the green sticky topics at this forums main page. There you'll find general guidelines about how this site and community operates (introducing yourself, posting files, netiquette rules, and so on).
Among them you're prompted to perform searches within this site before posting, because maybe your question had been answered yet.
Feel free to play with different keywords so as to be led thru a wide variety of articles and posts, and if you don't find anything that solves your problem or guides you towards a solution, you'll always be welcome back here. Tell us what you've done, consider uploading a sample file as recommended, and somebody surely will read your post and help you.
And about your question...
If you haven't performed yet the search herein, try going to the topmost right zone of this page (Custom Search), type the keywords used in Tags field when creating the topic or other proper words and press Search button. You'd retrieve many links from this website, maybe you find useful information and even the solution. If not please advise so as people who read it could get back to you as soon as possible.
Despite of this the custom expression for cell formatting allows you to specify four parts, so if you could handle to manage your requirements within that constraint you might expand Luke M's example and adjust values properly.
Regards!
Anbuselvam K
Member
Thanks for your prompt reply.
Already i have searched regarding my question but i didn't get proper answer. As per Luke M's reply we can make some standard letters whatever the numbers we will type
For Example "Trial Qty."0.000"M³"
Above example Trial Qty " " M³ it is a standard whatever the value i have entered it has display with the combination of what we define.
As per the cell value it has to be changed For example if we entered 0.03 it has to display 0.03 as well as 9cubes in behind of 0.03 weather it will be a shadow letter or some different character that we have to define.
Regarding this question already i have sent a mail to chandoo.d@gmail.com dated on 6 january 2013 16:03
As per Mr.Chandoo's reply i have posted the same question in our forum.
Already i have searched regarding my question but i didn't get proper answer. As per Luke M's reply we can make some standard letters whatever the numbers we will type
For Example "Trial Qty."0.000"M³"
Above example Trial Qty " " M³ it is a standard whatever the value i have entered it has display with the combination of what we define.
As per the cell value it has to be changed For example if we entered 0.03 it has to display 0.03 as well as 9cubes in behind of 0.03 weather it will be a shadow letter or some different character that we have to define.
Regarding this question already i have sent a mail to chandoo.d@gmail.com dated on 6 january 2013 16:03
As per Mr.Chandoo's reply i have posted the same question in our forum.
SirJB7
Excel Rōnin
Hi, Anbuselvam K!
Give a look at this file:
https://dl.dropbox.com/u/60558749/Multiple%20activity%20or%20display%20in%20a%20single%20cell%20%28for%20Anbuselvam%20K%20at%20chandoo.org%29.xlsx
It has a value table with a numeric and a string format for each range and displays values using the related format retrieved by VLOOKUP function.
Regards!
Give a look at this file:
https://dl.dropbox.com/u/60558749/Multiple%20activity%20or%20display%20in%20a%20single%20cell%20%28for%20Anbuselvam%20K%20at%20chandoo.org%29.xlsx
It has a value table with a numeric and a string format for each range and displays values using the related format retrieved by VLOOKUP function.
Regards!
Anbuselvam K
Member
Sorry i didn't get.