Is it possible to take the color generated from conditional formatting in a cell on sheet_1 and have that color value be painted or transferred into a cell on another (sheet_2) without writing VBA/macro code?
For example:
Cell B32 on Sheet_1 has conditional formatting that when TRUE turns the background cell color to GREEN. I also have it formatted to turn RED when another condition is TRUE. I want cell C1 on Sheet_2 to call whatever color value is in Sheet_1!B32 and show it on the other page.
Summary of performance of various products against target is as follows,
Product vs Target Color Code Result
CH4OH Green 1.0
[Code] ........
I need the final result automated as follows,
If 2 green of the 4 products, then final result Gree If 2 Amber of the 4 products, then final result amber If 2 Red of the 4 products, final result Red
We have a spreadsheet that is sent to a manager weekly. The manager takes the sheets from 30+ individuals and copies all into a single workbook that is then distributed to a very large audience and reviewed weekly. In this workbook, I have created drop downs with conditional formatting - Low = Green, Medium = Yellow, Critical = Red. On the original workbook, this formatting works great, however, after the manager consolidates and redistributes all worksheets the Green shows Gray, Yellow is OK and Red shows Black.
I have cells in my Excel sheet that contains boolean values, ie. the values TRUE or FALSE. Is it possible to format these cells so that FALSE is written with red color?
When using conditional formatting, I have it set to the following:
C2=60 (Reference Cell) C3=5 (Reference Cell)
Conditional Format Settings If C3 >= C2/12 then pattern set to Green If C3 < C2/12 then pattern set to Red
Here is the problem - when you have a value in C3, everything is fine, it's either green or red. If C3 is blank, it defaults to green because the conditional format is true.
Is there anyway to add something in there to have no color when C3 is not populated?
I have a column that when I put info in it gives me a colour, now on this I have quit a few different labels, eg. AAG201, PRA001, 000010 and so on, now on my rule I have put in that if it is PRA* ,AAG* to be one colour and 0000* to be a colour. (this is working without a problem).
I have tried to get the rest of the row to be the same colour, but cannot get te rules to work, I do not know which rule to use to get this working.
I am using the following code that I got from this forum to color tabs. But I can only get it to do two colors. Is there a way to get three conditional colors of tabs?
Private Sub Worksheet_Change(ByVal Target As Range) With Me Select Case .Range("D13").Value Case Is < 20 .Tab.Color = vbGreen Case Is > 20, Is < 30 .Tab.Color = vbBlue Case Is > 30, Is < 100 .Tab.Color = vbRed End Select End With End Sub
The code below turns numbers and dates on my worksheets(1) to text priorities on my worksheets(3), I now need to color the cell backgrounds of the results on worksheets(3). With formulas I know I can conditional format up to 3 colors (or 4 utilising the background) but I am after 6. I also know that you will look at my code and laugh as I should have done the color coding with the initial commands, but I struggled with it for 2 days and simply couldn't get it to work.
In the VB below it all works off a command button and up to the third color it works however it then gets stuck and throws up a runtime error '1004' Application defined or object defined error. I did get around this before by recording macros and effectively sticking them together but it hasn't worked on this occasion...... any ideas??? (I hope I'm not breaking any rules by pasting the code directly in?)
I have four conditions that dictate font colors in column "d" of "sheet1" and am using the following Private Sub Font_Change(ByVal Target As Range) Set Myrange = Range("D2:D1000") For Each Cell In Myrange
If Cell.Value = "Started" Then Cell.Interior.ColorIndex = 3 End If If Cell.Value = "Pending" Then Cell.Interior.ColorIndex = 4 End If If Cell.Value = "On-going" Then Cell.Interior.ColorIndex = 18 End If If Cell.Value = "Completed" Then Cell.Interior.ColorIndex = 6 End If
Next End Sub
1. Does this code look valid? 2. Do I paste the code in a "module" or in a worksheet object? If I add this to a module, how does the code know to reference sheet1? 3. Is there a handy reference guide that shows color codes? If so, where can I get a copy.
I need a formula to change the color of the cell based upon the following criteria
In cell I3, if J3>7 change color to teal, if H3<$A$1 color cell red, if J3<7 color cell yellow, if J3="COMPLETE" color cell grey, otherwise do nothing.
I found in the web-site a great VBA code that replaces the "Conditional Formatting" option in Excel. The problem is that it changes the "fill color" and I also want to change the "font color".
Private Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer
If Not Intersect(Target, Range("C4:C14")) Is Nothing Then Select Case Target Case 0 icolor = 2 Case 1 icolor = 4 Case 2 icolor = 39 Case 3 icolor = 45 Case 4 icolor = 37 Case 5 icolor = 15 Case Else 'Whatever End Select
suppose I have the numbers 1-25 in a column. I want to color the numbers 1,4,7,10,13,16,19,22,25 green, color 2,5,8,11,...25 orange and color 3,6,9,12...25 red. I can not set up the conditional formatting formulas correctly.
I'm trying to make a tracking sheet of upcoming annual inspections for different pieces of equipment. I've already got a column set up listing the inspection due date. Using three conditional formats, the individual cells change color based on the amount of time until the inspection is due (green normally, yellow at 30 days out, red past due).
What I'd like to do is have the entire row of information change color based on the color of the cell the inpection due date is listed in. For ex. J6 lists the inspection date as 24-Feb-07 and is therefore red, I'd like A6-I6 and K6-P6 to change to red as well. And when the inspection is compleate and I manually change J6 to say 25-May-07, I'd like all of row 6 to change green based on the fact that J6 is already going to.
Currently I have used all 3 conditional formats to colour certain cells.
1) Colour whole row 'green' when 'complete' colum ="Y" 2) Colour todays date column black in the date table to easily define todays activities. 3) By entering start and end dates that contractors are required, I colour these selected dates in blue with a letter 'x' in the calendar area.
This can easily be seen from the sample sheet above. If you can adapt this for yourselves carry on.
I am also using a macro (found in these forums) to automatically change the colour of the contractors tab to certain colours when selected from the drop down selection box (enabling more than just 3 conditional formats)
What I would like to happen though, is that when item 3 above is performed (select a start and end date) the filled blocks, colour the same as the contractor colour, instead of the blue with the 'x'.
I have conditional formatting set to paint the cells a certain color if the values are >0 and a diff. color if they are <0. If i enter the value manually everything is fine but if a use a formula to do the calculation there is no formatting.
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.....
Is it possibe to change another cells color (Fill) based on what is placed in that cell? Example: A1 =if there is an "x" in A2 highlight A1 Green, but I have information in A1 also. Or if I had a different cell say= if there is an X in A1 Highlight A1 Green ect.. This key is to highlight a cell that I have information in based on a different cell having an X in it. If ther eis no X in the cell I have indicated, nothing needs to happen.
I have this SS that uses conditional formatting to color days in a calendar, dates are entered in columns B & C when the dates are entered then the days of the month highlight. Everything works great but I can not get the conditional formatting to work in column E. Column E would be January 1. If I enter Jan 1 in column B & Jan 30 in column C all the days highlight except Jan 1? I have uploaded the SS.
