Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  Advanced Search
  HOME    TRACKER    Excel


Advertisements:










Concatenate And Bold


I have a simple concatenate in Excel...

=CONCATENATE(A1, ", ", A2)

Which produces:

This is, my text

Now, I want 'my text' i.e. the contents of A2 to be in bold.

I've played with the TEXT() function before, as per this page:
[url]

To get Excel to play nicely with date formats and stuff, however, my research has come to a dead end with Bold/Italic - with everyone suggesting that VBA is the only solution.

As I don't feel overly comfortable using VBA is there any other solution? (If not, is this a VBA 101 task or an advanced task?)


View Complete Thread with Replies

Sponsored Links:

Related Forum Messages:
Merging Cols Changes Bold To Non-bold Or Non-bold To Bold
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 Replies!   View Related
Make 1 Cell Bold If Another 1 Is Bold
I am trying to create a macro that if a value in a cell in column A is bold, then the value in the same row in column H is bold, then loop it to run on the rest of the worksheet.

View Replies!   View Related
Delete All Text Which Is Not 'bold' In Cells With 'mingled Bold' Text
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 Replies!   View Related
Concatenate Duplicates: Concatenate Results Of All Equal P/N's From Any Given List
I have a list of P/N's that are used in more then one location. and it's sorted by P/N's.

ColA__ColB__ColC
______Loc___PN
______1_____A
______2_____A
______3_____B
______4_____C
______5_____C

I Want to be able to put in Col A the concatenate results of all equal P/N's from any given list. Or at least select the few cells that i know are duplicates and from that copy the Location to a single Column.

ColA ColB__ColC
______Loc__PN
1,2____1___A
_______2___A
_______3___B
4,5____4___C
_______5___C

View Replies!   View Related
VBA Code To Bold Row Which Contains SUM
I'm new to VBA and needed help with:
I need to 'bold' the row which contains sum, the problem is that the location of the row varies depending on how long/short the report is....
Here is the code I used to bold a particular row:

Range("A14").EntireRow.Font.Bold = True

But instead of A14, i need it to be a row of no more than 5 columns, one of which contains the word 'SUM'.

View Replies!   View Related
Last Day Of Month Bold
Col. A are dates,I would like to format Cells so the last day of the month is bold useing conditional fomating


View Replies!   View Related
Bold Cell To Right If Cell Bold
i am trying to write a small piece of vba

basically if the cell in column "0" is bold then bold colum "o"
and "m" this must loop to last data row of colum "O"


View Replies!   View Related
Sort By Bold
I need to sort by cells that are bold. Does anybody know a way I can do this?

View Replies!   View Related
IF (A1 Font = Bold, A1+A2)
how to create an if statement based on font properties.

I did a couple searches on "conditional formatting" but didn't find anything, and it seems like the only way would be through a macro, am i correct? I'd much rather be able to do this on a formula sheet if possible.

View Replies!   View Related
Find And Bold
Instead of bolding only the cells with an asterick in them it will bold every cell with text in it. I also would like to adapt this code to only search through column A but have not been able to figure it out.

Sub FindIt()
Dim c As Range, firstaddress As String, ws As Worksheet, FindMe As String
FindMe = "*"
For Each ws In ThisWorkbook.Worksheets
With ws.UsedRange
Set c = .Find(FindMe, LookIn:=xlValues)
If Not c Is Nothing Then
firstaddress = c.Address
Do
c.Font.bold = True
Set c = .FindNext(c)
Loop While Not c Is Nothing And c.Address <> firstaddress
End If
End With
Next ws
End Sub

View Replies!   View Related
Find A String And Bold The Row
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 Replies!   View Related
Counting Bold Cells
in the Score column I want a 3 for the SnAkEs team and 7 for the dj2 team. How do I total up the bold cells?

View Replies!   View Related
Checkbox, Bold, Toggle
I'm having a problem making my font bold when I click on my checkbox and when I uncheck it I want the font to become unbold. I can make it bold when its checked but am not able to make it return to normal when i uncheck it..

View Replies!   View Related
Bold Unbold Output
im trying to write a function and i want output to be bold when integers are outputed i did it like

Range("years").Cells(j).Font.Bold =periods

which is fine but i want to clear cells each time program is run so i used

range("x").clearcontents

, but this only deletes the values, so my question is how to delete boldness as well? i tried using IF then false function but it didnt do the job. This is what i tried to use

For j = i To def_frq * i

periods = j / def_frq
If periods = i Then Range("years").Cells(j).Font.Bold = periods Else Range("years").Cells(j) = periods

If periods <> i And Range("years").Cells(j).Font.Bold = periods = True Then Range("years").Cells(j).Font.unbold = periods Else Range("years").Cells(j) = periods

Basically I use it to split year into however many periods so it will give me fractions of the year ,but i want to select in bold when it is the whole year.

View Replies!   View Related
Count Only Bold Entries
is there any way to get a formula to count only the entries that are in bold abd ignore all others

View Replies!   View Related
VBA Bold Selection Code
i'm using the following code to make a selection bold or not (basically as a replacement for the bold button). It works fine unless you select a group of cells...some of which are already bold and some of which are not...in this case it doesn't work....here is the code

View Replies!   View Related
Paste Values In Bold
Need line of code that can be used or modified such that one copy cell values and have them pasted in Bold?

View Replies!   View Related
Compare & Bold Matches
2 worksheets,
Sheet 1 columns A&B are the same as sheet 2 A&B.

Sheet 1 is my master list (customer name = column A and carrier name = column B)

Sheet 2 (customer name = column A and carrier name = column B)

Sheet 2 is where data gets dumped so I need to change font to bold when I click a check box on sheet 1 (master list) on Column C

Check box is on column C and column C will have more then one check box.

When I click check box on C I need date to populate on column D
(But when I re-open my workbook I don't want dates to change on me using the system date)

My objective is to select customer carriers on my master list sheet 1 and update date and change font to bold on sheet 2 so I can avoid or skip that customer carrier.

Hope this is not too much for my first post.

View Replies!   View Related
Determine If A Cell Is Bold Or Not
I'm trying to create a VBA module that will update data. However, I need it to skip any updates to data that has been set by the user. For simplicity, the user changes will be bold. I've found the info on the site for a function for counting cells in a range that are bold. But really just need to know how to get format of the cell.

View Replies!   View Related
Whole Row Of Active Cell Should Be Bold
The text of the active cell's row should be displayed BOLD. In other words, My cursor is on row 8, then this whole row should be bold. Is this possible ?

View Replies!   View Related
Sumif With Bold Condition
As a starter in VBA i have a lot of doubts... one of them is, how can i sum in a column the cells that are bold? i've thought that sumif was the trick, but i don't find the way to be able to adapt code.

View Replies!   View Related
Bold On Copying Cells Which Has A Forumula
when he copies some data across a worksheet - the new data has a bold format, so he has to unbold everytime.

I can't see any obvious reason why this is happening.

View Replies!   View Related
Copy Values If Cell Is Bold
I'm looking for VBA function in excel that will look up for bold cells in K column and copy values at the and of worksheet.

Lets say that cells K23, K56, K123 is bold. Macro will copy that cells to the end of worksheet with formula:
=+K23
=+K56
=+K123


View Replies!   View Related
Boarders Changed To A Bold Lines
On opening a worksheet. Can cell boarders X4 thru AF4 be changed to a bold lines and back to fine lines back and forth. Almost like a flashing cell?? Or even better like wave one after another?

View Replies!   View Related
Count BOLD Cells In A Column
How to count cells in a column that are in BOLD

I looked all over couldnt find it.


View Replies!   View Related
Format Particular Value Of Each Cell In To Bold And Colored
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 Replies!   View Related
Bold And Unbold Text Macro
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 Replies!   View Related
Automatically Copy Only BOLD Text
I have a spreadsheet with a pivot table in it. Column "G" has all of the data in it I need to abbreviate, problem is, I only want the values in BOLD face, and there are 3-5 rows seperating each boldfaced item. I would have to manually copy-paste each bold value into a new, 'clean' column ( column "I", or in a new sheet/workbook, it doesn't matter), and lather-rinse-repeat for the next 700+ rows. It sucks. No, it really does. I stumbled upon this website which is seemingly the utopia for excel macro and programming problems, so is there anyone out there that might take the time to walk me through it...?


View Replies!   View Related
Split Cells By Bold Text
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 Replies!   View Related
Bold Common Text In 2 Strings
I'm not too sure if this will be really easy difficult or really difficult but I want to write some code that compares the value of two strings, and any characters that arent in string 2 will be return formatted in bold. For example, if String1 was "The Quick Brown Fox" and String2 was "The Quick Yellow Fox jumped over the lazy dog", String2 would then be returned as "The Quick Yellow Fox jumped over the lazy dog".

View Replies!   View Related
Syntax For Bold&Red Marked Line
Below is a part of my code. But I am getting error on the bold&Red marked line.

View Replies!   View Related
VBA Macro To Bold 1st Words In Range
Here is my dataset... with ( cell references):

(Cell A1): "John: Apples, Oranges, Grapes"
(Cell A2): "Sally: Oranges, Peaches, Grapes"
(Cell A3): "Tom: Apples, Peaches"
(Cell A4): "Bailey: Apples, Grapes"

How do I get the text above formatted to bold the individual's names? Here is my desired result:

(Cell A1): "John: Apples, Oranges, Grapes"
(Cell A2): "Sally: Oranges, Peaches, Grapes"
(Cell A3): "Tom: Apples, Peaches"
(Cell A4): "Bailey: Apples, Grapes"

how to do this with visual basic ( VB) code. I need VB instructions to be detailed.

View Replies!   View Related
Formula Only For Bold Text Cell
i have a worksheet which has a price list for parts, about 2500 rows. in the Column C i have a retail price and in Column D have -5% of the C. i need to add Column E -10% of CERTAIN items, the ones in BOLD Only, of Column D. and change the color of that cell, is there a easy way to do this. i have attached screen shot what i mean.

View Replies!   View Related
Bold, Underline And Italic Greyed Out
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 Replies!   View Related
BOLD - Contents Of Cells In 2003
I cannot "BOLD" the contents of cells in my spreadsheet by clicking "B" on the menu bar. However I can do so by clicking on "Format - Cell - Font" and then using the selecting the Bold option. I wonder why this happens.

View Replies!   View Related
Make A Cell Font Bold
I have the following code that I am using for a header row of an excel sheet

View Replies!   View Related
Bold Selected Text In A Column
Every week I have a worksheet compiled with large range of data, being input after many meetings done. The action-owner Names in open/close brackets are among the long text input in one Column (there are not more than 50 rows of data).

My problem is that in the Column every time I have to manually Bold-face the owner names in the cells that have their names, pressing F2 and Bold. Examples: ...(Wilfred)... or ...(Jacky/Joseph)... Can someone please help me with a code, say I can list out a fixed list of selected text and such code will be able to have these selected text (which is names in this case) in the cells bold-faced.

View Replies!   View Related
To Bold A Part Of The Cell Text
I am creating a sheet with the cell information coming from different cells. I want to bold and/or underline a part of the cell to add clarity.

For e.g.
Cell A1 = "Trans X" (Name of the transaction);
Cell B1 = "System Y" (System where the transaction exists)
Cell C1 = "Type Z" (Type of transaction)

I want to create a cell which has
Newsheet.Cell (x,y) =
"Name: Trans X
System: System Y
Type: Type Z"

I created the String by reading and concatenating the values, but I am not sure how to add the formatting to a part of the string.

View Replies!   View Related
Auto Bold Filtered Results
I have designed a Macro to use an Advanced Filter to search for specific criteria in different columns. I would like the results to bold or highlight the cell if it meets the criteria for the advanced filter. There are multiple numbers in each row that are associated with each record, and I would like to be able to see which of these triggered the filter to work for that row by bolding or highlighting the individual cell.

View Replies!   View Related
Formula To Detrmine If Cell Is Bold
whether it is possible to have a formula determine whether a cell (say a5) is bolded or not? I know it is possible using a macro but in this case would prefer to use a formula.

View Replies!   View Related
Bold Part Text In Message Box
I've got a messagebox in my VBA code and I would like to bold the title of the filename that I've stored in a variable. My message box code (even though you probably don't need to see it) is as follows:

MsgBox ("There has been error. Please check the file - " & strFile & " and make sure there are no #REF errors." & vbCrLf _
& "If there are, correct the errors, save the workbook and regenerate the report. If the error still persists, reboot your machine and try again.")

Is this possible, and if so, how would I go about bolding the strFile variable?

View Replies!   View Related
Cell Bold And Font Size 12 And Highlight In Red
I am using this formula (Below) and it is working great. Only problem is that I want the client name to be be bold and font size 12, then I want it to highlight in Red. I also want the rows in colunm L to highlight in bright green.

Sub InputData()
Dim varUserInput As Variant
Dim LastRow As Integer

LastRow = Cells(Rows.Count, "G").End(xlUp).Row + 1

varUserInput = InputBox("Enter client name:", _
"Client Name", "")
If varUserInput = "" Then Exit Sub
Range("G" & LastRow).Value = varUserInput
Range("G" & LastRow + 20).Value = "Total".......................

View Replies!   View Related
Controlling Word And Making Text Bold
I'm using excel to open a new word document, stick some text on different lines and then save and close. The trouble is, I want to bold the titles but when I do I either bold or unbold the entire document. The codes looks like this:

With wrdDoc
With .Content
.InsertAfter "TEST"
.Bold = True
End With

.Content.InsertAfter [Word_WordCount].Offset(0, 1).Value
.Content.InsertParagraphAfter

, etc....

View Replies!   View Related
Make Part Of A Cell Bold Using A Formula??
I have a formula that combines the the text of various cells.

Is there a way to automatically make part of the cell Bold - so in this case I want the Cell B13 to appear in bold.

See formula below:

View Replies!   View Related
Make Text Dependant On Cell - Bold
i have some code where i need to make the text bold but not sure how to go about it
the formula is

View Replies!   View Related
Find End Of Column And Bold Rows In Loop
I am trying to Find a cell containing a string ("derf" in this case). Then bold the entire row and continue to loop till it hits the end of the row and column.
Here is what I have.

Sub Macro3()
Range("B65536").End(xlUp).Select 'Finds the bottom in column B and sets it to endhere
ActiveCell.Value = "endhere"
Range("A1").Select 'goto the top
Do Until ActiveCell.Value = "endhere" 'The Do Loop Starts
Rows("1:30").Select
Set rfoundcell = Selection.Find(What:="derf", After:=ActiveCell, LookIn:=xlFormulas, _
LookAt:=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, _
MatchCase:=False, SearchFormat:=False)
With rfoundcell
rfoundcell.EntireRow.Font.Bold = True
End With
Loop 'Keep looping till it hits the bottom of the columns row!
End Sub

View Replies!   View Related
Function For Determine If Cell Has 'mingled Bold Text'
I have the following formula (taken from the web) in my spreadsheet which let me know if a cell have bold text or not. But when the cell has 'mingled' text, i.e. only partly bold, he gave a #VALUE error.

View Replies!   View Related
User Define Function To Count Bold Cells
I currently have this macro that helps me SUM all the cells that are bold.


Public Function SumBold(Rng As Range)

Dim Total As Double
Dim Cell As Object

Application.Volatile
For Each Cell In Rng
If Cell.Font.Bold Then Total = Total + Cell.Value
Next
SumBold = Total

End Function

I want to have the same kind of Macro, but that could COUNT the number of cells that are Bold.


View Replies!   View Related
Bold Text In One Coloumn If The The Data In Another Column Is Checked
How can I change the format ie. Bold Text in one coloumn if the the data in another column is checked.

Basically, want the text in corresponding row of column "B2:B124" to be bold if the check box in the perspective row is checked?

View Replies!   View Related
Click Option Button To Make Cells Bold
Public Sub OptionButton1_click()
Sheet1.Select
ActiveSheet.OLEObjects("OptionButton1").Interior.Font.Bold = True

End Sub

The problem i have is when i click on one of the option buttons it should change the cells ive highlighted to bold.

View Replies!   View Related
Copyright 2005-08 www.BigResource.com, All rights reserved