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
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.
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.
I have got a userform with lots of controls,
One of the action's on a large group of the controls is the same but except for one number
here is an example
If TextBox107.ForeColor = 255 Then ActiveCell. Offset(0, 53).Font.ColorIndex = 3
If TextBox108.ForeColor = 255 Then ActiveCell.Offset(0, 54).Font.ColorIndex = 3
If TextBox109.ForeColor = 255 Then ActiveCell.Offset(0, 55).Font.ColorIndex = 3
This makes a cell that correlates to the textbox red if the text in the textbox is red.
Now, I loads of these textboxes that all need to run the same code with just the Offset value one digit higher than the last and I was hoping I could create a loop to avoid a huge block of code but I can't work out how to make a constant that will +1 with each loop.
Also, can I assume that a loop will start with the control with the lowest number i.e. Textbox1 and then work its way through the rest of them in order?
I have various row cells in column (F) filled with the color Green. And corresponding text in Column G. How can I change the text of that particular row to white.
i.e.: if any cell in column F is Green, change the text color of that row in Column G to white?
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 RelatedMy 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 Relatedlook 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 RelatedI 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 Relatedeach 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 RelatedWhen I enter some text into a TextBox, the first character is fine, but after the second character has been entered, the font seems to develop an underline. I've created a Word document with screenprints but have been unable to make it small enough to upload here, despite trying for the past couple of hours! You can therefore see the document here ... http://www.keepandshare.com/doc/view.php?id=508384&da=y
View 8 Replies View RelatedWhat 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.
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 RelatedHow would I compare two text fields (old and new) and change the font in the 3rd column (Difference)?
For example:
Old: I can not figure 3 things out.
New: I can't figure 2 things out.
Difference: can not can't figure 3 2 things out.
i want to color the text by using conditional formatting..for rank 1 i have give red color ,,, other then that everything is green,,,
ex...
Rank 1
Rank 2
Rank 2
Rank 1
Rank 1
Rank 2
Rank 2
FALSE
Rank 2
FALSE
I have a spreadsheet with a few thousand rows. How can I background color all rows RED that 'contain' the text "Ping" in column F, and also background color all rows GREEN that 'contain' the text "CPU" in column F, and so on....with more textual items that exist in cells in column F?
Possible to copy a cell from one sheet to another with the letter color?
Is there a function for this?
I need a script that will change the color of new text entered in a cell. What I have right now changes the whole text color in the cell, I only need the specific text that was modified.
[Code] .....
Is there a formula/code that can look at a spreadsheet, distinguish the color of the text (red for example) and throw out an "Exception" in a blank cell (in "A1")?
I have code to sum by color and for color index. However I want to sum by color if a cell is green for instance and the cell to the left = the word "Month". Is there a way to do this? Using sumifs or nested ifs?
View 3 Replies View RelatedI have a series of cells filled with a lot of html code, each to be edited. It is a tedious task to find and edit the required text. For easy visual reference, is there a way to color specific areas of text within a cell?
View 9 Replies View RelatedI'm looking to set my sheet up so that when I2 contains any text(date in this case) the whole row highlights indicating the package has been sent.
Title 1
Title 2
Title 3
Title 4
Title 5
Title 6
Title 7
Title 8
Date Shipped
Title 10
Text1
Text 2
Text3
Text4
etc
etc
etc
etc
15/07/14
etc
I am in need of a way to change the color of text in a cell to red if that cell contains a dollar sign ($) and if it dosen't contain a dollar sign ($) for the text to be black. I want this to happen automatically without having to run a macro, is this possible?
View 9 Replies View RelatedTried to record a macro which needs to color the cells which contains the following text, "Next mail needs to be sent", the problem which i am facing is; its currently coloring the cell which was recorded in the macro, which is G46, but i want all the cells which contains the above text to be colored.
Sub color()
Selection.AutoFilter
Range("A1").Select
Selection.End(xlToRight).Select
Selection.AutoFilter Field:=7, Criteria1:="=*Next mail needs to be sent*", _
Operator:=xlAnd
ActiveWindow.SmallScroll Down:=-3
Range("G46").Select
Selection.Interior.ColorIndex = 50
End Sub
Is it possible to have a code that says if I have a range of cells....say a1:d1 with d1 having a date in it....have that code say that if that date in d1 is greater than 30 days from today, make that whole range of cells (a1:d1) change color like to red.
View 9 Replies View RelatedTracking Snip.jpg
I have a tracking template to track the milestones of each data sets (received, etl complete, qa, live). In my status column I'm using the following IF formula to auto populate the the status:
=IF(ISBLANK(F3),"Waiting",IF(ISBLANK(G3),"Received",IF(ISBLANK(H3),"ETL Complete",IF(ISBLANK(L3),"QA","Complete"))))
However, I need to now start putting expected dates for these milestones in a grey text for each status. So none of the cells for the above formula will be blank. Is there a way to say if the text is grey, to ignore the date to auto populate the status column based on the black text that is available?
Currently F37 has a vlookup code that gives me text values and what I am looking to do is to color code these values.
For Example if the text value is GOOD, should be colored GREEN, VERY GOOD = YELLOW and OUTSTANDING = RED.
I have an Excel problem which I have been trying to solve for a while but so far I have had no luck.
I need a VBA script that can copy only text that has a font color of red from a cell. The cell has both black and red text. I then need to copy the result into an adjacent cell.
An Example (A1):-
This is an example of a cells content.
It has both red and black text.
I want the macro to search through column A and copy only the text in each cell that is red.
The result in (B1) will be:-
example of a cells
red
I'm trying to have the font color of a checkbox text change according to what's in a certain cell. For example, if cell "A1" = "Boom" then the font should be red. This is what I've written:
View 3 Replies View RelatedI want to change the text color of a grapg using VBA (chart name, data series, x and y axis names and scales changed).
The VBA code for changing text color is:
Code:
Range("A:Z").Select
Selection.Font.ColorIndex = 1
But I don't know how to do this for a graph!
