With a range of cells (a1:ao41) I want to color several cells depending on the value of that particular cell and another color when that particular and a corresponding cell have both the same value. It's some sort of sociogram The first row and column both contains names of students. Let say the students have to choose the three most populair ones to work with and the three most unpopulair ones. Positive ones get the color blue, negative ones get the color yellow. That's easy to do with conditional formatting. But now comes the tricky part. If for instance Student 3 chooses Student 7 and Student 7 chooses Student 3 the color of both cells have to be green if both positive and red if both negative. That's also do-able with conditional formatting, but it most be much easier to do with VBA. I just don't know how .
I had this question earlier and I dont know if it just isnt a regularly answered section so I though i would ask it here.....better yet I will just link to the other page so you can see whats up. Hopefully i will get a few more hits on it in this thread.
Cells in column B need to be colored red if they are equal to 50% of the cells in column C in the same row, or if the cell in column C in the same row is 100.
I have reviewed many a thread today looking up how to color in cells c11 through c20 without conditional formating.
if these cells have a time less than 01:00 then they turn green if these cells have a time greater than 01:00 then they turn red if the time is equal to 01:00 then they turn white.
I have two columns, A and B (I technically have a lot more in my sheet but to make it simple just focus on these two columns). The two columns are Company Name and then Company Color. I want to write a macro that based on what color is in Company Code (B1:B500) to highlight Company Name (Column A) based on those values in column B.
I am trying to make a certain cell range turn red on the week that a cell has listed.
What this is being used for is to track the work of our contractors, and I currently have this set up to auto calculate the jobs that are being done and when, but I would also like to include something in there that when the contractor is set to head back to India, that day forward is listed as "red" under his name. This will allow me to see if I need to extend his work based on the number of hours he has left in his jobs. I will attach the picture of it...on the top you will see dates, and the pivot table on the bottom shows when he will need new work, but I am going to add a field that has the date he is set to leave, this is what I want the coloring of fields to go off of! ...
I've an excel sheet...where I want to color the cells on the basis of following condition:
If Cell E is non-empty then cell A, Cell B, Cell C, Cell D, Cell F, Cell G, Cell H and Cell I can not be empty. If any one of the cell is found empty then color the respective cell in red!!If collectively all the cells Cell A, Cell B, Cell C, Cell D, Cell F, Cell G, Cell H and Cell I contains a value and Cell E is empty then highlight the Cell E in red color.
I would like to highlight cells is two conditions are met:Cell = 0Offset(0,-1)>0I tried the conditional format wizard and entered a formula: =IF(AND($J2=0,$I2>0)) But I keep receiving formual errors, which I understand, because it appears to be incomplete formula. But I am not sure what else I need to add to the formula in the conditional format wizard
I’m trying to change color in cell B9 according to different conditions in Cell C9 (than on b10 according to c10 and so long until necessary - probably will be around 2000 lines). Since there are more than 3 conditions and in two cases condition depends on the color of the C Column, I can not use conditional formatting. I’ve searched and found similar forums here, but since I’m ignorant in VBA code, I couldn’t manage to make adjustments. So if you can help me with the code, I would really appreciate it!
Condition and Results required would be:
IF column C = “S” than on Column B = color cell light blue with white border IF column C = “P” than on Column B = color cell Green with white border IF column C = “A” than on Column B = color cell Yellow with white border IF column C = “L” than on Column B = color cell Red with white border IF column C = “C” than on Column B = color cell Dark Blue with white border IF column C = “ ” than on Column B = color cell white IF column C = “V” and has white background than on Column B = color cell white IF column C = “V” and has a Dark Grey background than on Column B = color cell Dark Grey
Is it possible to set a formula or something up so that if a row contains certain information, then the row will turn a certain color? For instance, if cell B2 contain the number "3" and cell B5 contains the number "5", then row B will turn yellow. Then if cell C2 contains the number "4" and cell C5 contains the number "7", row C will turn blue. This is just an example. In this example, I'd like a formula all the way down column's 2 and 5, but only the rows would change color (not columns) according to their information.
I have got a Pivot table with makes and their sales in 2008 and 2009 like this 2008 2009 BMW 100 90 Audi 80 80 Mercedes 200 150 Fiat 80 120 Honda 100 110 Peugeot 70 120 (unfortunatley the formatting is deleted when posting).
I have created a stack column chart. In that chart I want certain makes to have certain colors like BMW = blue, Audi = yellow, Mercedes = black, Fiat = green, Honda = red and Peugeot = purple When I update the Pivot with a new month and a make changes position the colors go wrong. I would like to create a script that fixes the makers to their colors, so that after an update I can just run the script and am done .
Unfortunately I do not really know how to work with VBA (I can just steal macros and modify them a bit to my needs or use the recorder).
I need to coloring percentage values in excel 2000. What I would like to do is have percentages greater than zero shown in green, while negative values are red, and zero values are black. I currently have the custom formatting so negative values are red and all others are black, but I cant' seem to find a way to change it so greater than zero numbers are green and zeros are black. All I can do is chang positive and zero at the same time. Here is what I currently have:
I have this code that colors the lines in my Line Chart
Sub ColorLines()
Application.ScreenUpdating = False
Set chrt = ActiveChart 'Here you want to put your own graph vals = chrt.SeriesCollection(1).Values 'These are the values to determine later whether the line moves up or down. In this example, I just colored 1 seriescollection (= one line in your line graph), with an extra loop you'd do all lines.
It is very simple: When the lines goes up they turn black. When they go down they turn red.
The code work, but only if all cell in the series is filled. If one cells is blank the code error. I'm using #NA() in all cells that are blank, so the chart skip that cell and continue from the next cell's value.
i hav sheet containing list of employee number, think it is a labour camp, each room have four labours, each have a unique code. I made sketch in excel and enter all labour number in each cell, border them look look like a room, i have 120 rooms like that.
Now the problem :D, i hae different national labors
I have seperate list having their national according to their employee code.
Now i wanna color thier cell according to their national
I am searching a code and formula for last 45 days...
I had an report and the rows of the report needs to be colored based on another cell value. My layout looks like this:
A1B1C1D1AVG 1011121330 14151617100 18192021400
For each cell, i need to compare the value of cell with that value in AVG coloumn and if condition is met, cell should be colored. Eg : If first cell value under A1 is Less than 0.2 * AVG of first row then color of the cell A2 should be red. After coloring the entire rows, then i should check and color the header row based on the color of Rows.
I tried first one, i,e coloring the rows based on conditional formatting and then written VB code to compare the color of rows and colored the header row. But the color index used in conditional formatting and the code are mismatching and the desired output is not coming.So decided to write code for coloring the rows cell.
I am been trying to do a drop down only with coloring in Excel 2007, need not want any text to be the drop down list instead need a color specific drop down list, so that i could type a free text in drop down, which would enable to identify the content through coloring.
CompanyCodePropertyCount of StegdiwSum of WidgetsCompany XYZ
Example 1XXXXXX10.00Example 1 Total10.00 Example 2ZZZXXX22.00XXXZZZZ22.00Example 2 Total44.00 Example 3QQQZZZ33.00ZZZQQQ33.00QQQXXX33.00Example 3 Total99.00COMPANY XYZ Total1413
I am recreating a pivot table made by a prior user using new data. I have been able to figure out the format. But I would also like to color the sections in the same way, similar to that show above. How to color different sections of a pivot table?
I have an API, which inputs real-time stock data into an excel book. Does anyone know how to make the Last Price cell change coloer (Greem=up, Red=donw) depending on whether the price moves up or down, relative to the last price?
ie, over the course of a minute a stock may price at 35.00 => 35.01 (cell turns green) => 35.00 (cell goes red) => 34.95 (cell stays red) => 34.97 (cell goes green).
VBA, conditional formatting, or any other means of doing this is perfectly acceptable.
I've have two cell with data as below: CELL1: X1, X2, X5, X7, X8, X12 CELL2: X2, X5, X12
My question: 1. using macro to identify different data in the cell using color (for same data will be blue and different data will be red). 2. How to count the word in the cell (sample CELL1: after count will become 6 words)
I have one column ("Account Number"). Each cell in this column has some combination of 8 numbers (all formatted as "General"). Here's what I need:
If an Account number appears once in said column, do nothing. If an Account number appears 2,4,6 (any EVEN amount) times, make it a red font color. If an Account number appears 3,5,7 (any ODD amount) times, make it a green font color.
What has been tried: Using the "Conditional Formatting" tool in Excel slows up the spreadsheet way too much (it's a big file).
In posting macros I would like clor some lines of the macro. I tried writing the macro in microsoft Word and colored the lines and copying to the board, but the corlor does not come up.
I'm making excel macros for the first time and getting things figured out, but I have a few questions:
What code do I use to delete columns that have all empty cells EXCEPT the top cell (row 1) that contains any of a number of headings? I need to insert this into an existing macro.
What code do I use to fill color every other row (preferably even numbered) light grey after selecting a "currentregion" ? Again, to put inside an existing macro.
A related question: When I find code help on the web, it usually starts with "sub" and ends with "end sub" so how do I insert that into an existing macro? It looks like a "sub within a sub" doesn't work.
