Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Hi, If possible send that file and how do u send email through Outlook, OL express or through CDO. Sent on my BlackBerry® from Vodafone -Original Message- From: Rahul Kamal Gandhi Date: Tue, 30 Nov 2010 12:57:55 To: in.vaib...@googlemail.com Cc: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Bold a Text with Help Of Formula Vaibhav, I wrote an macro in excel where in the macro automatically find the to, cc, subject, mail body, attachment name, attachment extention, and attachment path, send on behalf of name The above attributes are already been defined in excel What actually I want is to do some formatting in mail body The trailed mail is carrying an example that how I need the bold in some parts of mail body Wanna help in VBA function. Sent from my iPhone On Nov 30, 2010, at 12:40 PM, "in.vaib...@googlemail.com" wrote: > Dear Rahul > > Pl explain the procedure, if you are saying you will be sending it to 9000, > then will you be using mail merge or not. > > If not how u will be sending (i.e. using which application) to 9000 employees. > > Rgds > > Vaibhav J > > > > On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. wrote: > Sir, > > Thanks for the prompt action, But I have a Data of 9000 Employees. > > I have to Send the Letters to Employees without using the Mail Merge. > > Only with The Hlp of Concatenate. > > Eg. > > ="Your Salary is increased with Rs. "&A1&"/- Please find enclosed > attachment which contains the breakup of amount" > > What actually I want is the Value which is derived from A1 should be > Bold. > > > Thanks. > Rahul Gandhi > > On Nov 28, 9:37 pm, Dilip Pandey wrote: > > Hi Rahul, > > > > I dont think there is any existing function using which you can bold > > at text. Considering your problem, I have thought of one smart way :- > > let say A1 has the text which needs to be bold. Go to B1 and type the > > formula =a1. Now apply conditional formatting in B1 that if cell B1 is > > not blank, then text should be bold. (=not(isblank(b1)) :) > > > > Best Regards, > > DILIPandey > > > > On 11/28/10, Rahul Kamal Gandhi wrote: > > > > > > > > > Guys, Can anyone Help me to Bold the text with the help of Formula > > > > > Eg. > > > > > A1 Cell Contains "ABC" > > > > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > > > > And My output should be *ABC* But in Bold Format > > > > > Any Formula or Code. Please Guys I am Struck > > > > > Regards, > > > Rahul Gandhi > > > +91-9711772297 > > > > > -- > > > -- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > > > -- > > Sent from my mobile device > > > > Thanks & Regards, > > > > DILIP KUMAR PANDEY > > MBA-HR,B.Com(Hons),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 62, India > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Vaibhav, I wrote an macro in excel where in the macro automatically find the to, cc, subject, mail body, attachment name, attachment extention, and attachment path, send on behalf of name The above attributes are already been defined in excel What actually I want is to do some formatting in mail body The trailed mail is carrying an example that how I need the bold in some parts of mail body Wanna help in VBA function. Sent from my iPhone On Nov 30, 2010, at 12:40 PM, "in.vaib...@googlemail.com" wrote: > Dear Rahul > > Pl explain the procedure, if you are saying you will be sending it to 9000, > then will you be using mail merge or not. > > If not how u will be sending (i.e. using which application) to 9000 employees. > > Rgds > > Vaibhav J > > > > On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. wrote: > Sir, > > Thanks for the prompt action, But I have a Data of 9000 Employees. > > I have to Send the Letters to Employees without using the Mail Merge. > > Only with The Hlp of Concatenate. > > Eg. > > ="Your Salary is increased with Rs. "&A1&"/- Please find enclosed > attachment which contains the breakup of amount" > > What actually I want is the Value which is derived from A1 should be > Bold. > > > Thanks. > Rahul Gandhi > > On Nov 28, 9:37 pm, Dilip Pandey wrote: > > Hi Rahul, > > > > I dont think there is any existing function using which you can bold > > at text. Considering your problem, I have thought of one smart way :- > > let say A1 has the text which needs to be bold. Go to B1 and type the > > formula =a1. Now apply conditional formatting in B1 that if cell B1 is > > not blank, then text should be bold. (=not(isblank(b1)) :) > > > > Best Regards, > > DILIPandey > > > > On 11/28/10, Rahul Kamal Gandhi wrote: > > > > > > > > > Guys, Can anyone Help me to Bold the text with the help of Formula > > > > > Eg. > > > > > A1 Cell Contains "ABC" > > > > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > > > > And My output should be *ABC* But in Bold Format > > > > > Any Formula or Code. Please Guys I am Struck > > > > > Regards, > > > Rahul Gandhi > > > +91-9711772297 > > > > > -- > > > -- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > > > -- > > Sent from my mobile device > > > > Thanks & Regards, > > > > DILIP KUMAR PANDEY > > MBA-HR,B.Com(Hons),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 62, India > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Dear Rahul Pl explain the procedure, if you are saying you will be sending it to 9000, then will you be using mail merge or not. If not how u will be sending (i.e. using which application) to 9000 employees. Rgds Vaibhav J On Tue, Nov 30, 2010 at 9:21 AM, Rahul Gandhi. wrote: > Sir, > > Thanks for the prompt action, But I have a Data of 9000 Employees. > > I have to Send the Letters to Employees without using the Mail Merge. > > Only with The Hlp of Concatenate. > > Eg. > > ="Your Salary is increased with Rs. "&A1&"/- Please find enclosed > attachment which contains the breakup of amount" > > What actually I want is the Value which is derived from A1 should be > Bold. > > > Thanks. > Rahul Gandhi > > On Nov 28, 9:37 pm, Dilip Pandey wrote: > > Hi Rahul, > > > > I dont think there is any existing function using which you can bold > > at text. Considering your problem, I have thought of one smart way :- > > let say A1 has the text which needs to be bold. Go to B1 and type the > > formula =a1. Now apply conditional formatting in B1 that if cell B1 is > > not blank, then text should be bold. (=not(isblank(b1)) :) > > > > Best Regards, > > DILIPandey > > > > On 11/28/10, Rahul Kamal Gandhi wrote: > > > > > > > > > Guys, Can anyone Help me to Bold the text with the help of Formula > > > > > Eg. > > > > > A1 Cell Contains "ABC" > > > > > I Want to write the formula in any cell, lets take Cell B1 > =AnyFormula(A1) > > > > > And My output should be *ABC* But in Bold Format > > > > > Any Formula or Code. Please Guys I am Struck > > > > > Regards, > > > Rahul Gandhi > > > +91-9711772297 > > > > > -- > > > > -- > > > Some important links for excel users: > > > 1. Follow us on TWITTER for tips tricks and links : > > >http://twitter.com/exceldailytip > > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > > > To post to this group, send email to excel-macros@googlegroups.com > > > > > <><><><><><><><><><><><><><><><><><><><><><> > > > Like our page on facebook , Just follow below link > > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;. > .. > > > > -- > > Sent from my mobile device > > > > Thanks & Regards, > > > > DILIP KUMAR PANDEY > > MBA-HR,B.Com(Hons),BCA > > Mobile: +91 9810929744 > > dilipan...@gmail.com > > dilipan...@yahoo.com > > New Delhi - 62, India > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Sir, Thanks for the prompt action, But I have a Data of 9000 Employees. I have to Send the Letters to Employees without using the Mail Merge. Only with The Hlp of Concatenate. Eg. ="Your Salary is increased with Rs. "&A1&"/- Please find enclosed attachment which contains the breakup of amount" What actually I want is the Value which is derived from A1 should be Bold. Thanks. Rahul Gandhi On Nov 28, 9:37 pm, Dilip Pandey wrote: > Hi Rahul, > > I dont think there is any existing function using which you can bold > at text. Considering your problem, I have thought of one smart way :- > let say A1 has the text which needs to be bold. Go to B1 and type the > formula =a1. Now apply conditional formatting in B1 that if cell B1 is > not blank, then text should be bold. (=not(isblank(b1)) :) > > Best Regards, > DILIPandey > > On 11/28/10, Rahul Kamal Gandhi wrote: > > > > > Guys, Can anyone Help me to Bold the text with the help of Formula > > > Eg. > > > A1 Cell Contains "ABC" > > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > > And My output should be *ABC* But in Bold Format > > > Any Formula or Code. Please Guys I am Struck > > > Regards, > > Rahul Gandhi > > +91-9711772297 > > > -- > > -- > > Some important links for excel users: > > 1. Follow us on TWITTER for tips tricks and links : > >http://twitter.com/exceldailytip > > 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 > > 3. Excel tutorials athttp://www.excel-macros.blogspot.com > > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com > > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > > > <><><><><><><><><><><><><><><><><><><><><><> > > Like our page on facebook , Just follow below link > >http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&;... > > -- > Sent from my mobile device > > Thanks & Regards, > > DILIP KUMAR PANDEY > MBA-HR,B.Com(Hons),BCA > Mobile: +91 9810929744 > dilipan...@gmail.com > dilipan...@yahoo.com > New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Dear Team, I Checked the appendedlinks, It only shows the Format, I want my output in bold format. Thanks On Nov 29, 3:54 pm, roberto mensa wrote: > 2010/11/29 Chandra Shekar > > > Hi, > > > Pls check this site it might help you. > > >http://www.mrexcel.com/forum/showthread.php?t=20611 > > > Thanks > > > Chandra Shekar > > get.cell returns (not set) information about the formatting, location, or > contents of a cell. > A function used in a formula can return a value. It cannot make any changes > to the workbook. > There are some exceptions: > > Merge > UnMerge > AddComment > ClearComments > InsertIndent > > regards > r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
2010/11/29 Chandra Shekar > Hi, > > Pls check this site it might help you. > > http://www.mrexcel.com/forum/showthread.php?t=20611 > > Thanks > > Chandra Shekar > get.cell returns (not set) information about the formatting, location, or contents of a cell. A function used in a formula can return a value. It cannot make any changes to the workbook. There are some exceptions: Merge UnMerge AddComment ClearComments InsertIndent regards r -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Hi, Pls check this site it might help you. http://www.mrexcel.com/forum/showthread.php?t=20611 Thanks Chandra Shekar On Mon, Nov 29, 2010 at 4:23 AM, roberto mensa wrote: > with UDF you can not: > look here: > > http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_the_worksheet_oh_yeah/ > > regards > r > > > > 2010/11/28 Rahul Kamal Gandhi > > Guys, Can anyone Help me to Bold the text with the help of Formula >> >> Eg. >> >> A1 Cell Contains "ABC" >> >> I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) >> >> And My output should be *ABC* But in Bold Format >> >> >> Any Formula or Code. Please Guys I am Struck >> >> >> >> Regards, >> Rahul Gandhi >> +91-9711772297 >> >> -- >> >> -- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> >> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts >> > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
with UDF you can not: look here: http://spreadsheetpage.com/index.php/oddity/a_user_define_function_cant_change_the_worksheet_oh_yeah/ regards r 2010/11/28 Rahul Kamal Gandhi > Guys, Can anyone Help me to Bold the text with the help of Formula > > Eg. > > A1 Cell Contains "ABC" > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > And My output should be *ABC* But in Bold Format > > > Any Formula or Code. Please Guys I am Struck > > > > Regards, > Rahul Gandhi > +91-9711772297 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Hi Rahul, You can do this with the help of replace option. Ist open the replace option by pressing ctrl + H. 2nd on "Find What" option write abc or any text you want to bold. 3rd on "Replace With" write abc or any text you want to bold. 4th on the right hand side of the "Replace with" option you will find "Format" option. From here you can chose any kind of format you want to replace with. 5th after selection the type of format, press the "Replace All" button. Hope this will sort your problem Thanks Simran On Sun, Nov 28, 2010 at 7:56 PM, Rahul Kamal Gandhi wrote: > Guys, Can anyone Help me to Bold the text with the help of Formula > > Eg. > > A1 Cell Contains "ABC" > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > And My output should be *ABC* But in Bold Format > > > Any Formula or Code. Please Guys I am Struck > > > > Regards, > Rahul Gandhi > +91-9711772297 > > -- > > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
Re: $$Excel-Macros$$ Bold a Text with Help Of Formula
Hi Rahul, I dont think there is any existing function using which you can bold at text. Considering your problem, I have thought of one smart way :- let say A1 has the text which needs to be bold. Go to B1 and type the formula =a1. Now apply conditional formatting in B1 that if cell B1 is not blank, then text should be bold. (=not(isblank(b1)) :) Best Regards, DILIPandey On 11/28/10, Rahul Kamal Gandhi wrote: > Guys, Can anyone Help me to Bold the text with the help of Formula > > Eg. > > A1 Cell Contains "ABC" > > I Want to write the formula in any cell, lets take Cell B1 =AnyFormula(A1) > > And My output should be *ABC* But in Bold Format > > > Any Formula or Code. Please Guys I am Struck > > > > Regards, > Rahul Gandhi > +91-9711772297 > > -- > -- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts > -- Sent from my mobile device Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
