I am looking to have the cells font color in each row match the color of the font in column D that will change depending on the info of the drop down box.
Sheet 2 is the one I am looking to work with as a test.
I'm using some basic code below in an on Workbook Open event to format cells with a value less then 2 and less than 1 with a particular color.
The code works, but it really slows my worksheet down when opening. Is there better way to write this?
Code:
Dim myRange As Range
Dim cell As Range
Set myRange = Range("V6:V50000")
For Each cell In myRange
If cell.Value < 2 Then cell.Font.ColorIndex = 5
If cell.Value < 1 Then cell.Font.ColorIndex = 3
Next
I have attached the relevant spreadsheet for which I need to alter the color of the columns based on Site number ( Sheet 1). % Mortality will be represented in the Y-Axis, and the Site numbers would be on the X-Axis. All columns (% Mortality) except one will be of the same color, and the one of a different color will indicate a specific site. As an example, site 86 is colored differently. The way I require the chart to look is shown on Sheet 1.
After reading through some great posts on Ozgrid, I managed to do this using conditional formatting (Sheet 2), but that sort of falls short because I am required to add a data table to the chart, and the parameter that is indicated by the column bars happens to appear twice in the data table.
I was wondering if this can be automated maybe using VBA, but with the possibility of simply matching the color of columns with the font color of respective entry in the data series.
I have attached an example file.. Basically I want the text in a range to change to red if one cell="Description".
Also, I want a cell's text to turn blue if it's corresponding data in the row says "Click on Title to Follow Link"
The example file explains it a lot better..
Thanks for the help.. Sorry if this may seem like a duplicate post but I was not able to get any of the examples I searched for to work that others have posted.. Also, maybe conditional formatting would be an option here but I could not get it to work as it will only meet the first condition that comes across thats true...
I'm trying to have a macro run to search a specific column (S) for a particular text value "y" and if true it will change the font to bold and the color to red for the entire row of the cell that contains the "y". the column is part of a data table that is constantly refreshed not sure if that makes a difference or not.
View 2 Replies View RelatedI have two conditions setup in Options>View - Zero Values.", "style="background: #FFFFFF;padding: 2px;font-size: 10px;width: 550px;"");' onmouseout='GAL_hidepopup();'>formatting.htm" target="_blank">conditional formatting. The first is setup for alternate row coloring with this formula inside Conditional Formatting:
Formula is = MOD(ROW(),2)
My Second Condition is
Cell Value is between $P$10 and $Q$10. This sets the font bold and a different color. The two cell values are two dates. I want to change the cells font color and bolding as long as the value is within that date range. It works fine, but for cells that are on the row that is colored the second condition doesn't apply for some reason.
I have two columns. The first one (A) contains cells that have different Fill colors. The second column (B) contains text adjacent to the colored cells. I am trying to change the color of the text in the second column (B) to the corresponding color in the adjacent cell in the first column (A). I don't think conditional formating works well in this situation. I believe the solution would be some sort of macro.
View 3 Replies View RelatedI have font color white in blank cells in column E and I (from row 5 to row 245) so the visitors will not see the text. If any of these cells become yellow (color code is 6), the font color will become black so visitors can see the text alot far better than white. I've tried this code myself after this post but nothing happen
View 4 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....
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 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 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 RelatedIs 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 Relatedhow can i change font color depended on (if statement)?
View 1 Replies View RelatedI'm working on a sheet. i should have blue and black font colors random. if i can have macro shortcut for blue and black, would save loads of my time.
View 6 Replies View RelatedUsing conditional formatting I can change the font color (to blue) of a cell if it meets a certain criteria. Now what I would like is to display a message when the color changes to blue. The cell range is E26 to E40.
View 9 Replies View RelatedI'm trying to get the font to turn red in column G if it is greater than or equal to column I, and get it to turn orange if it is between 80% of I and I. This is what I've got so far.
Sub Worksheet_SelectionChange(ByVal Target As Range)
If Range("G" & Target.Row) >= Range("I" & Target.Row) Then Range("G" & Target.Row).Font.ColorIndex = 3
If Range("G" & Target.Row) >= Range(("I" & Target.Row) * 0.8) Then Range("G" & Target.Row).Font.Color = 45
End Sub
I have this code for 10 Command Buttons to change the font colour. This is part of a much larger piece of code, but to simplify it, I am just using this
Sub ForeColour()
Sheet1.Cat1.ForeColor = &HC0&
Sheet1.Cat2.ForeColor = &HFF0000
Sheet1.Cat3.ForeColor = &HFF0000
Sheet1.Cat4.ForeColor = &HFF0000
Sheet1.Cat5.ForeColor = &HFF0000
Sheet1.Cat6.ForeColor = &HFF0000
Sheet1.Cat7.ForeColor = &HFF0000
Sheet1.Cat8.ForeColor = &HFF0000
Sheet1.Cat9.ForeColor = &HFF0000
Sheet1.Cat10.ForeColor = &HFF0000
End Sub
In Excel 2003, this code works instantaneously, but I am trying to run the same code in Excel 2000 and it takes 10 seconds. Is there any way that I can speed this up in Excel 2000?
The original file was created in Excel 2003, but I have created a new file in Excel 2000 with the 10 buttons on it and the code and it still takes 10 seconds.
I have a table - the first column is quantity, the others are descriptions, prices, etc.
I need to change the font of the other columns to white if the quantity cell is empty.
Jennifer Auto Merged Post;I'm still working on this, making baby steps. This is my code so far:
If Range("B26") = IsBlank Then
Range("C26:K26").Select
Selection.Font.ColorIndex = 2
End If
It works for line 26. Can someone give me a hint about how to make it do the same things for lines 27 through 62? Without having 35 IF statements in my code?
I was just wondering how I can type in a different colour. I.e. I have a document and I want to type in random cells but I always want to be typing in red, or blue etc. Hoe can I change the default text color?
View 8 Replies View RelatedI wrote a macro to do me page footers
Sub EditFooter()
With ActiveSheet
.PageSetup.CenterFooter = "Page &P of &N"
.PageSetup.RightFooter = "Préparé le " & Format( Date, "dddd, dd MMMM yyyy")
End With
End Sub
it works fine, howver I would like to change the font color to a light grey, and I have no clue how to do that.
I have a spreadsheet that i download from the net daily, which is seperated into columns of information.
I want to be able to look down a column and mark a cell in a seperate column if the cell font text is red.
For example looking down column A ... if the font text of a1 is red then mark the cell background colour of T1 red - if a2 text colour is red then mark the cell T2 red .... etc etc.
If the font colour in a1 or a2 ... etc etc is any other colour then do nothing.
I have 5 columns I wish to look down and mark in 5 seperate columns - I have tried to do this by conditional formating but don't know the fomula for checking font colour.
Using excel 2007. In a A table of marks obtained by a student. I want to get the content of the cell be displayed in a bigger font and in a particular color when i point to it. When I point to a cell content the display should be in a color of my choice say green and the font be greater than 20 pixels.
View 1 Replies View Related