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
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.
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?
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,...????
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.
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.
When 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
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.
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?
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?
I 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?
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?
Tried 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.
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.
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?