colors

Hi, all, Trying to find a way to explain what I need so bear with me. My daughter and I have setup 2 marble tracks. We have 5 sets of colors marbles and we want to have mini tournaments (seasons) racing the 5 different colors over 2 tracks. It is very easy to calculate the W/L as a total...

Hello everybody, this is new! You know, sometimes Excel feels a little nostalgia of those moments when he drives you nuts, and decides to reiterate. What about this time? Since yesterday he decided to not to show cells fill color anymore, but! • Only if you open pre-existing Excel files. If...

Hi I would like to keep the same chart colors when using slicers depending on the brand vendor. However, let's assume my chart has 4 vendors Vendor A - green bar Vendor B - blue bar Vendor C - yellow bar Vendor D - red bar If I pick the four vendors it will show the colors mentioned above...

Excel can display 16,777,216 colors. 4,096 squared. How would I go about writing a macro that would show every 4,096th color?

I need a macro to: - Remove the numbers for number bulleted items - Remove the letters for alpha bulleted items - Insert two line breaks after each sentence - Replace → with [space]>[space] - Remove [space]▼ (replace with nothing) There can be as many as 20 bullets; they can go beyond E and 7...

I would like to have a formula in, say, cell A2 that determined if cell A1 had a fill of either of two standard colors (the ones labeled "standard colors when you drop down the fill menu) and then returned a value--orange=1 and blue=2. If the cell isn't filled with one of the two colors, I want...

Hi there, I have been presented with some 20 plus templates, each workbook/template contains between 5 and 20 sheets, depending on the sheet, they make have extra items, charts, different shapes and maybe some tables. I have been told to change the generic colours to keep up with the new...

Good day! Here's my problem, that i can't really find the solution. I have a table simmlar to this, <tbody> Color name R G B Cream 252 255 217 Magenta 222 0 237 Pink 255 92 217 Lilac 151 116 204 </tbody> I have 150 of these colors. I'm planning to make 3 inputs as my lookup value...

Hello all, I was hoping that info from the macro recorder would help, but it didn't do so well. Here's what I have: With Sheets("Scheduler") .Cells(I + 85, j + 2).Value = "hi" '.Pattern = xlSolid '.PatternColorIndex = xlAutomatic...

=IF(AND(D12="Fixed",D26<>J75,G50=J75,OR(D26-J75>0.125%,D26-J75<-0.125%)),CONCATENATE("APR difference between ELC (",TEXT(D26,"0.0000%"),") and Final CD (",TEXT(J75,"0.000%"),") not within tolerance"),IF(AND(D12="Fixed",D26<>J75,G50=J75,OR(D26-J75<0.125%,D26-J75>0.125%)),CONCATENATE("APR...

Hi there, Trying to use VBA for apply conditional formatting to a chart of data. Would like to see all cells in the selected range with a value greater than or equal to 0.65. The code I have works, somewhat, but only checks if the first cell in the row has the value, not each individual cell...

Hi Everyone, I'm very new to Macros and I know very little about VBA. I have recorded over and over my macro. I set three different conditions so that it changes the font and background color depending on the keywords. The weird thing is that when I try to run the macro in another worksheet...

Hello. I am tracking multiple sheets to when people answer the specific questions. I have tried to use a VBA but have been unsuccessful with it. Below it the VBA I used, and what I am trying to do. Function GetColorCount(CountRange As Range, CountColor As Range) Dim CountColorValue As Integer...

I have a worksheet that will be copied from a pivot table. The columns will remain static however the rows will change with each new pivot table. I have a code that will highlight the header columns blue. Is there a VBA code to sum the ranges between the 2 colors? I have provided an example...

I have a small column chart that pulls the x value from column Q (eg. Volvo, Honda, Toyota, etc) and plots it vs a rating in column R. The vehicles in Q come from a dropdown menu of 8 choices, and I want the colors of the bars to change depending on what vehicle is chosen. The order is not...

I have a very simple conditional formatting problem. I have a table like this: I want to have each new door number's row be highlighted, for example the first one 114 can be white, and the next one 115 gray, then 122 white, 123 gray, 129 white, 130 gray... etc etc... AKA I want it to look...

I am trying to have two If statements in one formula. I am trying to have all cells from C3:C32>5% in addition to cells I3:I32>1.9% highlight. I do not want it to highlight unless both criteria is true. If both are true I want the cell in I3:I32 to highlight. Please let me know I really...

Hi All, Had to register to this formu, i just cant work it out alone. So my issue is to bring the information from dif tabs into one Summary Tab. Now variables: -Information is not on the same cell. -There is no easy formula to transpase colors (green, yellow, red) - It may or maynot be...

Ok, hopefully this can actually be done. When I’m in excel and click the ‘Fill’ or ‘Text Color’ drop down, I am presented with ‘Theme Colors’ which displays the matrix of 10 colors and then 5 rows of corresponding hues, and ‘Standard Colors’. In my line of work, the consistency with colors used...

Hi everyone, I am using excel 2007 and need to use pie charts for a presentation. My boss insists on using one of the pre-set styles ("Chart Style 11", a lot of shades of blue). However, I need to manually create a legend in powerpoint using text boxes, and I'd like to fill in the text boxes...