colors

  1. J

    IF statement dependent on cell fill color

    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...
  2. K

    change colours or propeties on all items

    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...
  3. X

    Please help me regarding extracting results from 3 nearest value /criteria

    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...
  4. andrewb90

    Change Color instead of value in VBA

    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...
  5. G

    Cells aren't color coding?

    =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...
  6. C

    VBA Condtional Formatting for Chart

    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...
  7. G

    Recorded Macro changing format of conditional formatting

    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...
  8. B

    VBA for count background color of cells

    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...
  9. J

    VBA to Sum Range Between Colors

    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...
  10. E

    Conditional formatting with Column Chart

    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...
  11. svendiamond

    Conditional formatting different number = different color going down column

    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...
  12. M

    Two If Statements in One Formula

    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...
  13. Y

    Copying Formatting (color) from different tabs (issue is cells are not on the same cells on each tab)

    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...
  14. A

    Standard Color Set Excel

    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...
  15. J

    Getting the RGB code off of Excel's pre-set Styles (Excel 2007)

    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...
  16. A

    Conditional Formating in VBA

    I am new to VBA and want to create a macro which will add conditional formating to the columns which I insert. I need each row to be formated the same. I want it set up so that if the row (D4:D29) says borrow it highlights the highest rate. If it says lend it highlights the lowest rate on that...
  17. S

    Counting or summing cells that are highlighted a certain color

    Is there a way to use a formula to count or sum only cells in a column that are hightlighted (filled) a certain color?
  18. Gingertrees

    Meaningful way to easily (not mysteriously) change colors in my macro?

    In my macro, I utilize conditional formatting to create alternating rows of color. The powers that be have tired of the sage green I've been using. How do I easily change the color in the following piece of code? Say I want to change it to pink, and then later on I change my mind and want to set...
  19. B

    Creating Silver and Gold Colors

    I am needing the silver and Gold colors. Do you no how I can find or how to create these???
  20. A

    RGB contrast COLOR Formula

    Need help to calculate the contrasting colors for given set of RGB values. For a <code> sub contrast() r=127 g=127 b=127 activecell.font.color=RGB(r,g,b) new_r=255-r new_g=255-g new_b=255-b activecell.interior.color=RGB(new_r,new_g,new_b) end sub </code> does not help when r,g,b values near...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top