i have a string in a cell, that would say "Your results are -10% for the week". is there any way to change the font to red, for the number, including the minus sign preceeding it, and the percent sign following it. all are in one column, about a thousand rows. the rest can stay black.
View 5 RepliesI have a button (shape) whose text value is linked to cell A1. (In other words, if text in cell A1 changes, the text on the button changes). A concatenation formula exists in cell A1 to "join" together a combination of text and cell values. The formula in A1 looks something like this:
="You have "&B10&" records that contain errors."
I'd like to set the font for the "&B10" portion to be a different color than the rest of the text string so that it stands out from the rest of the text. Obviously this can be done when the text is manually entered into a text box, but when using a formula to populate the text in the text box, it's all or nothing. I'm hoping to find a way to embed a separate font color within the formula string in A1 for just the portion I want to change? For example, all text would be regular/black, but the numeric value generated from cell B10 would be yellow.
Looking for VBA that can change the font size of "•" char(0149) within any string in selected cells.
Also looking to delete the last "•" char(0149) within any string of selected cells.
What would the syntax for these two functions be?
I have a udf that returns a string to the cell. The string is made up of multiple string "objects". What I am wondering is if I can set the font color of certain objects so that when the final string is built and returned, the font of those portions is set.
Ex. of simple idea (this is not actually my code, just a way to illustrate. I realize there is no point to this UDF):
VB:
Function StringReturn (Str1 As String, Str2 As String, Str3 As String) As String
StringReturn = Str1 & Str2 & Str3
End Function
Now what if I wanted Str1 and Str3 to be blue, and Str2 to be red for example. So that when the UDF calculates it would return: Str1Str2Str3
I'm taking some university classes and one of them is called Applications Programming and we have been using excel VBA. I have a project that I'm working on, and it's very basic. Basically we need to create a userform that has 3 option buttons, 4 check boxes, a couple labels and a couple text boxes. It's suppose to be a ice cream selection terminal. Option boxes for basic flavors of ice cream, check boxes for toppings, one text box for user input of number of scoops of ice cream and the last text box to output a reciept/overview of purchase.
So here's the question... I was wondering if there's a way to change the font of a single string variable, or change the font of a word within a string. My output to the saleBox(My receipt overview) is this:
saleBox.Text = ("Thanks you for your Purchase") & vbCrLf & vbCrLf & _
"You ordered " & numOfScoop & " scoops of " & flavorChoice & "ice cream" & vbCrLf & _ "Topped with: " & toppings & vbCrLf & vbCrLf & total
(not sure how the code is gonna look in the message but I'm sure you get the idea)
i want to be able to change the font for the flavorChoice or toppings variables. They are both strings.
Anyways, I know I can get away with basically what I have there and get full marks, but I like going above what the basics are. If it's kinda complicated.
I'm gonna attach a screenshot, more info is better than not enough right... nevermind its askin for a url!
*** I just now got the idea of putting another textbox over the area that would output the text I want to change and hide the border or something and then change the font of that text box through the properties ***
how to or if it's possible to change the font color of a string variable? or is there any workaround?
View 2 Replies View RelatedI found what looks to be a BASIC or perhaps early C form of code that will do exactly this, however I am finding it out of my grasp to 'convert' the below code over to VB for Excel, and I was hoping someone would be able to piece it together for me. Code128B is a barcode font that requires a 'computed' start and end bit, as well as a checksum character(s) in order for the barcode to be valid and readable by barcode scanners. This code (in whatever it is written, I don't really know), is said to do just that. Code:..................
View 4 Replies View RelatedSomehow my tab names (in 2003) have a very small font size. How do I return the size to normal?
View 5 Replies View Relatedtry explaning this again....Also conditional formatting will not work...
Looking for a formula in excel to do this---
I have a lottery numbers system in the 3 digit and 4 digit
numbers...In row A we have the 3 digit that were drawn about
3000 ---3 digit numbers and in row C we have also 3000 numbers
for the 4 digit ....All we need to do is Highlight All the
even numbers and make them RED font---in the 3 and 4 digit rows...
Is there a way to do that?????
A--row-----C--row
123---------4429--make the 2red in the 3 digit row and 442red
in the 4 digit row.
033---------5579--nothing in this row
229---------2200---etc....
this forum have as to change the color of the Font in a MSGBOX?
View 9 Replies View RelatedI want to change the font colour in row J7:J299 if there is perticular word say "Double" in row J.
I would like to address this:
If cell in column1 is filled (.Interior.ColorIndex = 15) then font color is 0 in any cell of that row.
(right now the color is red and I cannot change this at the source but will have to add a sheet change event maybe)
I use the "custom header&footer", and I want to to change the color of font, but I don't finde this choice!
View 9 Replies View RelatedI am wanting to be able to find the last row of data (range changes on a monthly basis) and change the colour of the font to white for the entire row. I don't want to delete the row as contains totals but want the font not visable.
View 2 Replies View RelatedIn sheet1 I have a simple database consisting of 5 columns of data
Column A : Name ie James Jones
Column B : payroll number ie 123456
Column C : shift times ie 1245-2124
Column D : job title ie floor
Column E : comments ie A/L or 0600-1500
what I would like is some code that will go down Column E and if a 'time string' ie 1300-2130 is found then copy this string and paste into corresponding value in column C. If a text string is found ie A/L or Sick or anything like this then ignore and move onto next cell, loop this until all cells in column E have been checked.
I'm creating a simple spreadsheet totalling units of alcohol up. Is it possible to change the colour of the fornt when different values are reached? For example if a total of under 8 units is reached this is displayed in green, if over 8 the figure is shown in red.
View 4 Replies View RelatedI have a coworker trying to create a dropdown list and is using wingdings for the checkmark, x, and other symbols for filling out for. Everything works great except when you click in the field the drop down box doesnt show the wingdings font but the corresponding arial font. Is there a way to change the dropdown box to wingdings because currently the dropdown box shows various 'u's with different grammatical stresses.
View 2 Replies View RelatedI'm trying to use Excel to keep team standings for a baseball board game. I had no problem calculating wining percentage. Finally figured out how to calculate 'games behind.' Now I'm wondering if there is a way to change the font color of a team name based on their wining pct?
A typical row contains: A2(Team Name), B2 (Wins), C2 (Losses), D2 (Pct (B2/(B2+C2)), E2 (GB). Is there a way to use the IF function to return the 'Team Name' in green if D2>.500, 'Team Name' in red if D2<.500, and 'Team Name' in black if D2=.500 ??
I am trying to figure out what the formula would be to change the font color if the entered number is less than the quota.
I'm making a spreadsheet for work that each of the reps will punch in their daily numbers, and, for example, if there quota was 70 and they are <70 than the font will turn red, and if greater or equal to 70 it will turn green.
I am looking for the best way to change the font of cells in a Worksheet that contain a formula. I have used Go To-Special-Formulas but have one slight problem with this method. It highlights all cells that contain an "=" sign. Some cells may be linked (ie cell A2 may say =cell A1). How would I change the font only for cells with a Function such as Sum or Vlookup and not for cells that simply link to another cell?
View 7 Replies View RelatedI have the following formula:
=temp2!BN466&" / "&ROUND(F155/temp1!BN466,0)
Which gives me a result of 2 / 3
Is there anyway to change just the color of the first result? The "2" to red?
I cannot do it in the cell because of the 2 results being combined into 1 cell so I'm wondering if the formula can be modified to change the color of the 1st result.
macro that will change the cell color based on text? I have a list of titles in column B. Everytime the word 'Car' is found in this column, I would like to change the font color in columns C-G to the color white within the same row.
View 9 Replies View RelatedI want change color Font depending in my if then else.
I have workbook with several sheets, but i need change colorfont Is that validation is true.
The number are in Sheets("PSDATA").Range("AA")
Private Sub color() .....
This appears to be so simple, I've searched the forums and have found almost the right VB code but not quite.
I have a 3000 row spreadsheet with various columns.
Column M can either be PASS, FAIL, REJECTED, IN PROGRESS or NOT ASSESSED.
I need the rows (A to M inclusive) to change colour and text colour dependent on this condition.
I almost had an answer with Select.Case but I couldn't get the formula to work with text, only numbers.
I have a user that was recently upgraded to Excel 2003. He has a problem when changing font color in a cell. Anytime he changes the color of the font to red and then clicks another cell the color reverts back to Black. Now when he clicks on the cell it displays the color red in the formula bar but no in the cell. it also displays the correct color in hte print preview screen. this happens no matter what Excel file he is wokring in.
View 6 Replies View Relatedhow to make the word pink in the following
enter the GL account in question in the pink box
But the same is not possible for the word green in the following.
=IF(D3="Check to see if this is a vendor restricted from VULCAN", "Enter vendor number in the green box WITHOUT leading zero", "")
Is there a way to make green green?
Is there a macro or code snippet that can change the color of the font while i am typing in the cell. Means that if the font color int he cell is originally RED, i can type and change it to another color using VB code.
View 2 Replies View RelatedI've created a combo box in excel with the macro recorder. This is the code that came back:
Sub test1()
ActiveSheet.DropDowns.Add(1305, 52.5, 242.25, 39).Select
With Selection
.ListFillRange = "$AW$4:$AW$18"
.LinkedCell = "$AX$5"
.DropDownLines = 5
.Display3DShading = False
End With
End Sub
This always results in a default font size of 8 for my list. Can anyone tell me how to modify the code above to change the font size to 14? And how to modify the color of the list.
how can i change font color depended on (if statement)?
View 1 Replies View RelatedI have a workbook that includes a drop down list with three options. One of the options is "TA". The default font type for these cells is "Wingdings" but when "TA" is chosen I want the Font Type to change to "Arial".
View 11 Replies View Related