Format String Text - Underline Or Bold

Jul 23, 2012

Can Excel format text in a formula?

i.e.: =if(R25>6"This is Simple test", "This is the other part part of the test")

and then underline the word "Simple" or to have the word "other" bold.

View 4 Replies


ADVERTISEMENT

Excel Custom Format A Value With Bold And Underline

Sep 26, 2011

The formula is ="Total: " &SUM(B2:B10) Can you make the result appear bolded and underline. Just the result from the =SUM formula not the text Total.

View 1 Replies View Related

Format (Underline) Text With A Formula?

May 19, 2013

I need to underline text which is populated from a formula. How to format numbers, dollars and dates within a formula, but how to underline text.

Desired Result: The employee's who sold more than 100 cars this month are: Alex, Mike and Tim. Please congratulate them on their performance!

Formula being used ="The employee's who sold more than 100 cars this month are: "&cell reference&"Please congratulate them on their performance!"

Current result: The employee's who sold more than 100 cars this month are: Alex Mike Tim Please congratulate them on their performance!

Attempts: I wish underlining text were an option within Format Cells/Custom so I could just use the formula =text(cell reference, "underline"). However, I don't see that as an option in the 2007 or 2010 versions. Is there a way to add "underline text" as my own custom format?

I also tried using "Conditional Formatting" (both "Format cells only that contain" and "Use a formula to determine which cells to format)." I can't quite get it because I don't know how to list names for the former conditional formatting. Vlookup is the only way I know how to refer to a list for the formula based conditional formatting, but this would stop after the first name on the list is found and ignore the rest of them.

View 9 Replies View Related

Bold, Underline And Italic Greyed Out

May 8, 2009

My spreadsheet is locked and protected, and i have found out that the BOLD, underline and italic functions have been disabled, is there anything i could do via VBA to keep these functions active,...????

View 4 Replies View Related

BOLD And UNDERLINE Concatenated Cells

Apr 23, 2006

I need bolding and underlining cells that are "Concatenated". For example, cell format for cell K12 is already bolded and underlined. If I concatenate (C1,K12,D2) I get a result that doesn't carry over the format of those individual cells - particularly K12 which I want BOLDED and UNDERLINED.

View 9 Replies View Related

Revert (Bold) Underline Back To Normal

Jan 12, 2014

What I mean by my "bold" underlines:

QRG5UUl.png

Notice the difference between the bold underline and the normal ones. There is also some weird thing happening where in some cells, when I use the underline feature, it shows as a bold underline, but once I've pressed enter to move on to another cell, the underline reverts back to normal. If I select to edit (F2 or double-clicking) said cell, the underline becomes bold, and vice versa (s3lw.png).

All this started happening immediately after I did this (was just experimenting, and I have no idea what this actually does, or if it was the cause of those occurences): Insert > Symbol > Special Characters > No-width optional break. I did that to just one cell though, and now all this weird stuff is happening.

View 4 Replies View Related

Copy Format And Bold Titles In String?

Apr 24, 2014

I'm working on a Excel template where 6 cells are filled with text. Now I want to put all the text in those cells into one 'result cell'. I already know how to put the cell values into strings and paste them beneath each other.

My problem is that I don't only want to copy the cell values but also the formatting, because all of the separate cells have a bold title. If I only copy the values the formatting isn't copied with it, so my question is:

How do I copy the cell formatting (bold titles) with it or how can I make a string bold?? Beneath is my code:

[Code] ....

View 12 Replies View Related

VBA Bold Specific Text In String

Jan 28, 2014

I'm using the code snippet below to add text and apply formatting to a cell within a given sheet.

[Code] .....

I'm now trying to amend this so, the word "All" is in bold text and I've recorded the a macro, and have the following:

[Code] ....

The problem is, is that when I try to amalgamate the two, I'm unable to get this to work.

View 8 Replies View Related

Macro Seems To Make Entire Text String In Cells Bold

Aug 1, 2014

I have the following code:

[Code] ..........

However, whenever I run the code, if there's even on word that is bold in the cell, then the entire text string in the cell turns bold. How can I stop this from happening? i want to keep the format of the text string the same, only remove and replace the items listed in the code.

View 4 Replies View Related

Copy Any Bold Text Within Cell Text String To Adjacent Cell?

Jul 31, 2014

Here's an interesting one:

A1 contains a text string which is both bold and unbold (
B1 is blank

I need a macro which scans the cells with text and copies the BOLD portions of the text string into the adjacent cell.

Example:

A1
The sky is blue

Macro is run

B1
sky blue

View 11 Replies View Related

Delete All Text Which Is Not 'bold' In Cells With 'mingled Bold' Text

Jan 23, 2010

I want to have a function or macro that if cells have mingled bold text, that only the bold text shall remain in the cells, and all the rest of the text must be deleted.

View 4 Replies View Related

Underline Text With Different Color

Aug 24, 2009

Is it possible to underline text with differenet color? Text is let say std. black, and need red underline. (I can change color of cell down but I would like underline line in right test test. underline.xls

View 3 Replies View Related

Finding Text String & Format

Apr 10, 2008

I have a mass of text in a cell. I would ideally like to search the text to format in a different font colour so it can be easily seen where the specific text is.

My current way is to use SEARCH in conditional formatting but this changes the whole cell not the specific text I am interested in.

EG. - I interested in the text PETER in my cell so would like PETER to be in red font.

A peck of pickled peppers Peter Piper picked; If Peter Piper picked a peck of pickled peppers, Where's the peck of pickled peppers Peter Piper picked?

View 10 Replies View Related

Find A String And Bold The Row

Oct 15, 2008

I am using ctrl+f to find a string that may or may not be in a worksheet.

If it is found, i need to bold the row.

If it is not found, i need to go on to the next instruction in the macro.

I just don't know quite how to combine the If/Then with Find.

View 9 Replies View Related

Merging Cols Changes Bold To Non-bold Or Non-bold To Bold

Jun 8, 2008

I am merging columns. Col B has all text in bold. Col C has all text in regular font. When I use ASAP to merge, the merged column comes out all bold. When I use a formula to merge the merged column comes out all regular. What I want is for the merged column to contain the bold text from Col B in bold, and the regular text from Col C in regular.

What I want is...

This is for service plan B: Take all data and transer to new server.

What I am getting is...

This is for service plan B:Take all data and transer to new server.

OR

This is for service plan B:Take all data and transer to new server.

View 9 Replies View Related

Changing Date Format In A Text String?

Jun 18, 2014

So I'm just a lowly intern who has been given the task of changing date formats in a bunch of spreadsheets. The string is as follows:

1015 Dixon Schwabl Est. for Creative Svcs 101207.pdf

I have to change the date at the end (mmddyy) so it reads as yyyymmdd. There is a long column of these strings, and i have to do it on over 300 spreadsheeys.

View 3 Replies View Related

Embedding Date Format In Text String

Jun 6, 2006

I want to format my spreadsheet title so it reads number of reports for june 2006

="number of reports for MM YYYY"

So far all i get is -

="number of reports for 6 2006"

using my code which is

="number of reports for "&$BD$2&" 2006"

View 6 Replies View Related

Bold Repeated String In Cell?

Aug 29, 2012

I am trying to write some code that will look in an excel cell find if it contains the word that I am looking for and make it bold. I have written the following code so far

VB:
With Worksheets("Label Print").Cells(i, J)
.Characters(Start:=InStr(.Value, "Name"), Length:=Len("Name")).Font.Bold = True
End With
[COLOR=#3E3E3E][B][/B][/COLOR]

The issue is that if "Name" occurs twice (or more) in a cell it will highlight only the first.

View 1 Replies View Related

Finding Text That Matches Format Criteria In String?

Oct 3, 2011

I'm trying to restructure a list of files at work into a format that makes some sort of sense and can be filtered into useful information.

Part of what I need to do, is match up all the drawing numbers that a certain project references. The numbers are formatted like "####A##" ex. 1234A01,1234A02,5678A01, etc. The cells that I need to extract drawing numbers from contain some description or other text (not just the drawing number) so I need to extract the drawing number from that cells value. (Ex. I need to get the drawing number 1234A01 from a cell whose value is "blah blah 1234A01 blah blah blah")

I was thinking I could just search the string for "####A##" but I'm not really sure how....I tried instr, but I think its searching for the literal value of "####A##" rather than treating the # characters as wildcards...

I tried:

Code:
if rngNames.Cells(intx, 2).Value Like ("*####A##*") then
set intStart = instr(1,rngnames.Cells(intx,2).value,"####A##")
'....
end if
but intStart remains 0, so this method is not working...

View 3 Replies View Related

Adding Bold Tags To Parts Of A String?

Oct 21, 2011

I'm trying to figure out a macro that will add b and /b tags around bold text. Bolded text can appear multiple times within a cell. I need it to run on all cells within a sheet.

So I need it to:
1. Search for bold strings within cells
2. Identify the length of the bolded strings
3. Add b and /b at the beginning and end of those strings
4. Repeat for all active cells

The only macro I was able to work out adds tags to only the last bolded string, whereas I need the tags on several non-continuous strings.

View 9 Replies View Related

Custom Cell Format - Number Ending With Text String

Jun 13, 2013

How to modify a custom cell format to make data entry easier.

My goal is to have the output look like this: 'A12B-C20D: SET 10: Text string here'

Inputs needed are:

1-3 digit number between A & B
1-3 digit number between C & D
1-2 digit number after SET
Text string of variable length

Where I am stuck. So far I can get "A12B-C20D: SET 10:" to show up properly when 122010 is input. The custom format I am using looks like this: "A"##"B-C"##"D: SET "##": "

When I try to incorporate the "@" symbol the first part of the formatting goes away and the output shows up as "122010 Text string here".

I have tried:
"A"###"B-C"###"D: SET "##":";;-;_@
"A"###"B-C"###"D: SET "##": ";;@
"A"###"B-C"###"D: SET "##":";_@
"A"###"B-C"###"D: SET "##": ";;;@

View 4 Replies View Related

Extracting Specific Information From Text String To Conform To Format To Upload Into QB

Mar 21, 2014

I have a string of information in an Excel download from PayPal that I need to upload into QB; but, the information needs to be in a different format. The string from the download is:

Property Address - 1116 South PaxonBorrower " Testa and Son Contractors,LLCLoan # - 1402088Acct Executive " Brandon Tully

But, I need it to be:

1402040;TPAPR;141 North Clinton Street, East Orange, NJ 07017;Leslie P Carter

Is there a formula that I can use to extract specific information from the original string into columns so I can then concatenate the columns into the information I need to upload? Or is there a better way to do this? The Property Address and Borrower Name are not static sizes so I can't use a formula that counts spaces.

View 3 Replies View Related

Format Particular Value Of Each Cell In To Bold And Colored

Jul 8, 2009

I have a question regarding the formatting of cell values. Is it possible to format particular value of each cell in to Bold and Colored?

For example in the below example for cells A1 to A5 contains some values.
I want the value BBBBB to be bold and with red color font.

Title
AAAAA BBBBB CCCCC
DDDDD BBBBB EEEEE
BBBBB GGGGG HHHHH
LLLLL AAAAA BBBBB

View 9 Replies View Related

How To Convert Date (text String) Into Date Format

Jan 17, 2012

I have these as input entered as text:

January 01, 2011 January 01, 2011 February 28, 2010 May 12, 2011 June 02, 2010 February 28, 2010 May 12, 2011 June 02, 2010 February 28, 2010

but I need it in this DATE format:

MM/DD/YYYY

I need it as a formula to be entered into a cell in excel (not VBA)

View 9 Replies View Related

Split Rows By Bold Text?

Oct 7, 2013

I have an Excel sheet with 2 columns : Date and TextColumn

The TextColumn column contains in each cell text such as this :

Title1
TextLine1
TextLine2
Title2
TextLine3
TextLine4
....

I need to split each line as follows : Each title (in bold and on a new line) and the text who follows should be placed in a new row, copying the date in each new row created.

View 1 Replies View Related

Bold And Unbold Text Macro

Apr 25, 2008

i'm trying to write a macro that does the same thing as the bold button. Click once and the text is bold, click again and it un-bolds.

View 14 Replies View Related

How To Make Certain Text In Comment Bold

May 25, 2009

I need to figure out how to make certain text bold in a comment using vba. I'm making it so it adds a comment that looks like this:

View 7 Replies View Related

Bold Selected Text In A Cell?

Sep 16, 2012

I'm trying to use the below vba code that was provided by another member. The code show work to bold any text that is found matching the text string provided.

Problem I'm having is that I get a 'Type mismatch' error when the code tries to run, as below:

Public Function Colorandbold()
'USE-COLOR AND BOLD TEXT STRINGS WITHIN TEXT EXCEL VBA
'BROUGHT TO YOU BY WWW.PROGRAMMINGLIBRARY.COM
'CREATED BY MARK SLOBODA

[Code].....

View 4 Replies View Related

Bold Specific Text In A Cell

May 22, 2014

I am trying to bold specific text in a cell. I have found some language that will do this trick to a point. In addition to the word "Foxwood" I would like to bold 9 other specific words in 5 different sheets in this workbook. Is there a way to do this without the cumbersome task of repeating this language 5 times for the different sheets and 9 times for the additional words?

Dim startPos As Integer
Dim totalLen As Integer
Dim searchText As String
searchText = "Foxwood"
For Each cl In Sheets("Week1").Range("c3:c100")

[Code] ....

View 5 Replies View Related

Split Cells By Bold Text

Jul 22, 2008

I have a sheet full of names, addresses and phone numbers in one cell like this


Albert Young 16 teststreer 12C..................7888-6338

The name Albert Young is bold. The thing is I would like to split the cell putting the names in another colomn. Then it would be ideal to split the addresses and phone numbers as well. But I have no idea how to split any of these. I scanned this from a phone book, the dots are different on each row.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved