colors

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

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

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

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.

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

I need to highlight in different colors the different formats listed below in a single column. 123RMW 1234RMD TA12345RM 1234RM I have used "if contains D", "if contains W", and if Contains TA" for the first three (all in different colors). I can't figure out how to highlight the last one. It...

I know how to sort by color for a column. What I want is to sort a column by multiple colors, i.e. just group the colors together. They dont have to be in any specific order, just grouped together. Is there a macro or code I can write to do this? Thanks

Dear All, I would like to know how can I conditional format this chart: Objective: "Change the color of graph to “Red” or “Green” depending on Achievement %age in cell “B40 to G40” in tab “PDV”. Currently, the graph colors are different (random colors). Change the color of graph to “Red” or...

Hello Everybody. I work long hours on my laptop and I'm trying to customize a little the appearance of my PC. I'd like a DARK theme, but unfortunately, Windows 7 doesn't think I deserve it: I managed to get a dark theme (without aero) but this changes the "default colors" and excel became...

Hi, How do i write a code to count total of "blue" and "red" in each school? The sum of blue and red have to be written at the cell next to the school. Colors other than blue and red are ignored. The rows in each school is inconsistent. <tbody> AB School 4 Blue Blue Red Red CD...

I'd like to toggle through 3 colors red yellow and green. On click I'd like to be able to change the color of a text box to these colors. I'm up for ideas so far I've been able only to change the color of a text box based on a formula or the color of the cell with a click, but the cells are too big.

I know this looks daunting, but please don't turn away just yet. :) The concept of what I'm trying to achieve is simple, but requires a lot of detail to paint you the right picture. I'm trying to create a way for users to assign colors to projects in a dynamic list. So when the user makes a...

Dears, I would like to create a sub or function and inform the type of data I'm working with. Each data type has a specific color. In the other sub I'll have to write a lot of lines, with different colors, depending on its type. So, how can I do it? Is it possible to create a sub, define the...

Hello, I have a column of email addresses were I search for duplicates and give each grouping of duplicates a different fill color so there are an unknown number of fill colors and the duplicates are not in any particular order in the column I want to sort my sheet on the fill colors so they...

Hi All, I would like to have a table where the rows have alternating colors, but without the use of table formatting (because it slows the excel too much down). AND after filtering the rows should still have alternating colors for the visible rows. The last part is what I'm struggling with...

I have a training spreadsheet that I am tracking 16 different trainings for about 30 people. I have the dates the training was complete out next to their names. All of the training is annual, so I would like to have the colors change as the exp date approaches. If training was completed...

Hi I have more than 10 different list with different categories for example I have a cosmetic shop with different Goods and colors powder 4 colors 206-207-208-209 lipstick 8 colors 301-302-...-308 foundation 6 colors 501-501-...-506 and I have more than 20 goods my question is how can I...

Hi there, What I am trying to do is conditionally format a comments column based on what control code is used. so that if a certain project code is used the comments column turns red UNTIL IT IS FILLED OUT. Once the comments section is filled out correctly it should go back to the regular...

I am trying to come up with a macro to sum the below data based on cell color and text color but am having issues. The data is in cells B2:D45 and the different fill colors are blue and red. The different text colors are black and yellow. Any help would be appreciated. Thanks,

Is there VB Code to get a cell date to change to different colors in this format <= 30,20,14,7] days? Thanks in Advance