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


ADVERTISEMENT

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

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

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 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 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

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

Summing Concatenated Cells

Dec 7, 2006

I have concatenated the following cells:
A1, B1, C1

The data in each cell is:
1, +, 2

I can concatenate them to show "1+2".

My question is, can I then perform the calculation that the concatenation produces?

I would like to be able to enter different operators into B1 in order to carry out different calculations.

View 9 Replies View Related

Searching Concatenated Cells On A Sheet

Oct 27, 2012

Concatenated cells. My issue is how do i search through a sheet with cell values that have been concatenated?

Lets take an example:

I would like to search for a string call sales in sheet1 which would display all the employees and schedules for that department (do note that employees can be part of not just one department). but my cell formatting is as follows:

Sheet 2, Column 1
Employee name

E.g. Row 2 Employee1

Sheet 2, Column 2
Department (cells concatenated)

E.g. Row 2 Sales, Marketing (Concatenated Cell)

Sheet 2, Column 3
Work schedule

E.g. Row 2 8 AM to 5 PM

So when you search for sales, it will display employee1 and work schedule.

View 1 Replies View Related

VLOOKUP Or SUMIF With Concatenated Cells

May 23, 2008

I have a worksheet that is utilizing a VLookup to pull some values from another worksheet based on a composite number. I have checked the numbers for their format, length, and value (dangling spaces, etc.). I still cannot get this VLOOKUP to work correctly. I have attached the file.

Column H on the Cost Report sheet holds the formula in question. It concatenates the values in Columns C,D,E,&F to create a composite number to look for in Column B of the Original Estimate sheet. It is supposed to pull the $ value from Column D of that range.

I have tried everything. I passed the composite number into TEXT, --(Double Unary), INT, tested for both #'s length with LEN and have converted the formatting between text and numbers.

View 6 Replies View Related

How To VLOOKUP A Value In A Another Sheet And Return Concatenated Values Of Other Cells

Nov 27, 2013

I need to do a vlookup of the values of Sheet 1 Column A (Ref) in Sheet 2 Column A (Ref).

The results will be the concatenated values of Sheet 2 Column B + C + D + E to be displayed in Sheet 1 Column B (Address).

I'm not sure how I can do this using formula.

I've attached a example.

View 6 Replies View Related

Cell Addresses Derived From Concatenated Values In Separate Cells

Apr 2, 2013

I need to return a value from a cell in Column H, but with a row number that varies with each entry.

I repeat this formula every 5 rows or so. But the cells referenced on another spreadsheet are only one row apart. Because of this discrepance, when I copy my highly developed cluster of formulas, they only reference every 5th entry on the other sheet. What I've been doing is manually altering long, complicated formulas by hand. I can't do a replace function because every once in awhile it'll find an extra instance of the digit I'm replacing and mess up parts of the formula I don't want changed. I could avoid this tedious, time-consuming work-around if I could make a formula that would do something like this:

=Display Value from in column H: (row number per cell B1)

And cell B1 would include the number 3789.

So the returned result is the value from cell H:3789

View 4 Replies View Related

Cell Value Of Closed Workbook With Concatenated File Path In Cells

Sep 24, 2007

I have a report that is collated from several other workbooks. The source workbooks follow the same naming convention throughout the year and so I have managed to concatenate the file path to bring through the text of the filepath and cell reference however cannot work out how to get the value of the cell. For example, I have the file path in A1, file name in B1 and sheet and cell referernce in C1.

I am using {=(A1&B1&C1)} which gives me R:CONFIDENTIALREPORT FOLDER[REPORT 24.09.07.xls]Sheet1!$D$1. To make matters slightly more difficult, the source reports would be closed. Is there an easy way or am I going to have to do this in VBA.

View 4 Replies View Related

Counting Bold Cells

Apr 10, 2007

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 9 Replies View Related

How To Run Macro If Selection Is Not Bold And If Bold Then Do Nothing

Aug 5, 2012

How do we run a macro if the selection is not bold and If bold then do nothing.

View 3 Replies View Related

Make 1 Cell Bold If Another 1 Is Bold

Oct 2, 2007

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 9 Replies View Related

BOLD - Contents Of Cells In 2003

Nov 12, 2008

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 2 Replies View Related

Count BOLD Cells In A Column

Sep 7, 2007

How to count cells in a column that are in BOLD

I looked all over couldnt find it.

View 9 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

Bold On Copying Cells Which Has A Forumula

Oct 17, 2008

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 9 Replies View Related

How To Count Bold Cells In Excel Sheet

May 28, 2013

How to count the bolded cells In an excel sheet using the formula

View 1 Replies View Related

Making Cells With Text Bold And In Grey

Jan 16, 2012

I have a spreadsheet with rows of cells which are either blank or have text in them.

Is there an easy way to write a formula which will make the cells which have text in them bold and make the cell colour grey. But if the cell is blank keep the cell white.

View 3 Replies View Related

Click Option Button To Make Cells Bold

Mar 25, 2007

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 9 Replies View Related

User Define Function To Count Bold Cells

Oct 16, 2007

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 9 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

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

Highlite Or Underline Active Cell Row

May 28, 2009

Is there any way in excel to allow for whenever clicking on an active cell to make an underline or highlite the entire row that that cell is in?

View 2 Replies View Related

COUNTIF Function To Autom. Underline

Aug 18, 2009

look at the attached file. How can I have the text values in Column A automatically be underlined if the concerning value in Column C drops below the value "1"? Note that Column C wont give you number values in this sample book as it refers to another file on my hd.

View 4 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

Underline Word In Concatenate Function?

Apr 22, 2014

each cell contains one word say hello in a1 and Henry in b1. Is it possible to underline Henry after =concatenate(a1,b1) ?

View 4 Replies View Related







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