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 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?
How 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 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?
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 RelatedPossible 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!
I am having a hard time figuring how to change the color of all the different text groups in a chart, header, axis, labels etc, and even the macro recorder has failed me this time - I have recorded the following, where I selected the graph, changed textcolor to white and then ended the recording - but without changing anything in the code, it returns an error on the second line (starting with "with"):
Run-time error '-2147024809 (80070057)':
The value is outside of the boundaries (translated from danish)
ActiveSheet.ChartObjects("Chart1").Activate
With ActiveSheet.Shapes("Chart1").TextFrame2.TextRange.Font.Fill
.Visible = msoTrue
.ForeColor.ObjectThemeColor = msoThemeColorBackground1
.ForeColor.TintAndShade = 0
.ForeColor.Brightness = 0
.Transparency = 0
.Solid
End With
From what I have read, it might be something with the textframe2 property.
I would like to change the color of my text on my X-axis of a graph. I would like to have 4 or 5 different colors to identify different categories. I see how I can change all the text but how would I change just the text in column 1-3 to red, column 4-7 to blue, etc...
View 2 Replies View RelatedIs it possible to have a If statement based on the cells text color.
ie
If(color of A2=RED,1,2)
So if Apple text was colored red the result woud be 1
If the Apple text was black the result would be 2
How To Change The Formula Text Color
=B5*B6
Make It
Red Bold
=B5*B6
I have text boxes in excel that hold text (obviously) over a period of several days. It gets updated daily, so I want to change the font color for the new text that is added daily rather than all the text. Is there a way to do this?
Also, is there a way to get the verticl scorll bar to always show on the right hand side of the text box? The way it is now, I have to click once or twice in the text box before it shows up. I would like the person reading it to automatically know that there is text not presently in view so they know to scroll down for more information.
I've got a spreadsheet where there are three columns (a-d)
Now B-D contain dates and I'm looking for A to be coloured conditionally so if column B contains any text, then A's background will be red, if A & B contain text, then it'll be orange and if A & B & C contain text then it'll be green.
What I can't seem to work out is how to get this to work in this order only - ie my version with conditional formatting means if someone entered text in D and nothing in B & C it'd turn Red...
Is it possible to use different text colours as part of the [Value_If_True] or [Value_If_False] when using an IF formula? For example =IF(AS3<34,"ok","not ok")
In the above formula I would like the “ok” value to be in Blue and the “not ok” value in Red.
See attached work book, it is an mot booking system that is all working fine except for one thing that I don't know how to change.
At the moment if you double click a cell in the test type column it enters the required data and turns the cell green highlighting the length of time and values this is all good but I am wanting the ones that start with n-side to turn yellow just so that we can see our own internal tests easily. It is control in the coding not formatting . Is there a way this can be done?
In a cell I have this formula to tell me what day of the week the previous date falls on. =TEXT(J77,"ddd")
I want to know how i can format that column so that weekends are in red.
I need to be able to assign colors to cells depending on what text is inputted.
If a name start with letters between:
A - Cald (I want the cell to be Yellow)
Call - Eg (I want the cell to be Black)
Ek - Hall (I want the cell to be Red)
Etc.....