colors

  1. M

    Display my chart's font fill color and transparency percentage for all series on a "Chart Details" range of cells

    I'm using Excel 2016. As I keep fine-tuning my stacked area chart's configurations, I find it hard to keep track of the fill colors and series colors. I want to display, for example, in cells B40 and C40 series1's Fill color hex code and series1's Fill color's transparency. And then B41 and C41...
  2. L

    VB colors name list

    Hi I have seen values like vbgreen, vbblue,vbred etc. Is there any list that show all VBColor list? like the list below but more colors. Thank you very much souce: https://excelabcd.co.in/2018/12/lesson123-how-to-change-cell-color-with-vba
  3. S

    Find conditionally-formatter cells in a given range

    Hi I have set of numbers in a range , say B2:F6, that are colored differently due to conditional-formatting. I'm looking for a sub to find/identify say YELLOW cells in range B2:F6, then copy YELLOW cell values, then paste the values into YELLOW col. starting in cell B10, and do same for other...
  4. L

    Worksheet Copier

    Hello, Does anyone know code that will copy a template worksheet multiple times? Original Sheet Name: Week Template I plan to have one worksheet for each week in the year (52 plus the 'Week Template' sheet Paste conditions: 1) row height 2) column width 3) fonts style sizes and colors...
  5. M

    Hot Keys for colors

    Hi, Is it possible to set custom hot keys for colors? For example, instead of Alt+H+H and then arrow keying to the color I want to select, is there a way to set Alt+H+H+1 to, say, white, and Alt+H+H+2 to black, Alt+H+H+3 to the third color in the palette, etc.? Thanks!
  6. W

    Is there any way to highlight the first two rows automatically after applying filters in a worksheet?

    is there any way that I can coloured the first two rows in a worksheet automatically after applying the filters?This is the overall problem :I have got a sheet with columns like thisitem price criteria1 criteria2I have to frequently filter and note down the price of the first two rows of the...
  7. T

    formatting cell that contain

    is there a faster way besides using conditional formatting to color specific columns like in VBA. I want to have the cells for example in C4-C53 g4-g53 k4-k53 etc etc to change colors if they are less than or equal to 1. i have 40+ columns to do so as you can see doing it in conditional...
  8. R

    How to set the color theme through VBA

    Hi All, Can anyone suggest how to set the colors theme- Office 2007-2010(Menu-> Page Layout->Colors->Office 2007-2010). I want to do this through VBA. thanks Rajneesh
  9. E

    how to change chart line colors in vba 6.0?

    Does anyone know how to hange chart line colors in vba 6.0? I tried the way vba 7.0 uses to change them, but it fails. I can't update its version or install an updated excel cos it's my company's pc and they forbid any new app installation.
  10. K

    Macro for tab colors based on column value

    Hi all, I'm trying to format my tab colors based on cell value in column I. Example: "At Risk" - Red Tab "In Progress" - Green Tab "Not Started" - Yellow Tab I need it to apply to all worksheets, range for all worksheets is I9:I30 All the macros I have tried don't seem to help me. Please...
  11. K

    Changing colors

    How do I get VBA to look down a column of dates and it the date is less that the date in cell A1 it fills the cell color with red and if it is equal to or 30 days out it colors the cell yellow?
  12. P

    returning a concatenated text list reflecting non-zero values

    Hi. I have a data set that is annual values for various colors. For each of these colors, in any year the value will be 0 or greater. For each year, I would like to have a cell list all the colors that are non-zero for that year. For instance, for the table below (apologies for formatting)...
  13. S

    Dependent drop down lists for groups of items

    I would like to modify my existing drop down lists to dependent ones. I have followed some of the online tutorials and made some of my own samples to learn how do make a basic dependent one. I would like to know if something is possible and below is a small sample of what I am working with...
  14. I

    How to ADD Colors to Excel

    how do I add more than 64 colors on excel 2000 or 2003? ?
  15. A

    IF, AND, VLOOKUP help

    Hello, I am trying to do a If And with a vlookup within the same workbook. IF(AND(IF(AF3431="Red",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Blue",VLOOKUP(AG3431,'VLookup Table'!E:F,2,FALSE),IF(AF3431="Green",VLOOKUP(AG3431,'VLookup...
  16. P

    Drop down question

    Hi .. I am trying to create a drop down of lets say toys where I have the option of choosing the color. So, I have 10 toys .. each of these ten toys are available in a range of colors. Not all toys have the same colors available. I need to be able to select a drop-down list for the toy #1...
  17. L

    bar chart: vary colors by point option

    Hi Yesterday, I inserted a bar chart. I right clicked on any bar in that char and then clicked on "Format Data Series" then Click on Fill icon, but could not find []Vary colors by point!! I am not able to reproduce that issue again! My question do you know under which circumstance that option...
  18. D

    Multiple Colored Sheet Tabs

    I now reference my sheets by color as a quick index, However i would like to sub reference a few. Do you know if it is possible to have more than just one color in a sheet Tab? I would like to be able to have 2 colors or 3 even on some. Excel 2016
  19. T

    Change Cell Color after date has passed.

    I have columns A6 - F6. Column A6-A56 contains the days date. I want the cell color to change to yellow after each day passes. For example on 9/26 I want all the cell colors for 9/25 to change colors. I retired and don't use excel much and have forgotten a lot. Your help is appreciated.
  20. S

    Custom Fill Color Tool with Specific Colors and Associated Hot Keys

    Hi Everyone, Long time Excel user who recently started a new job that involves lots of formatting with various company specific colors. I want be able to insert each of the colors to various cells quickly...ideally with just a couple key strokes. Thus my thought process was to create a tool...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top