My pallet lost color-coding - if I hover over each little scare it displays the names for the colors and if I click on them they color the cells with the right colors, but the palette itself lost the visual display of colors except for 8 colors: black, blue, red, magenta, yellow, cyan, and white.
I use color-coding of cells a lot and I find it difficult to work without visual clues. At least the hover-support allows me to get the work done, but with difficulty.
The following code is the code "behind" the run button on my userform. The last section reads in a column ( of numbers and text) into a listbox based on the users choice. Is there any way I can have only certain rows in a different color - based on either if the value in that row is greater than a certain number of if the text in that row is a particular sentence?
Private Sub CommandButton1_Click() 'Dimension all variables Dim fqc As Long Dim eptg As Long Dim newlabel As String Dim BorC As String Dim now As Long Dim secondorthird As String
'Collect User Choices fqc = TextBox3.Value ' Final Quiz Choice eptg = TextBox5.Value ' Expected Post Test Grade BorC = TextBox4.Value ' Is desired grade a B or C now = TextBox6.Value ' Number Of Weeks after term has started secondorthird = "second" If (now = 3) Then secondorthird = "third" .....
I am trying to create a Holiday/Absence Sheet that will count up hours of Holidays, absence, business Visits etc etc.
The only way I can think of doing this is by colour and filling the cells with the Number of hours holidays, Absence & Business Visits but to do this I need to create a formula that will sum by colour. I've tried a variety of things and I'm sure this can be done using VBA but it's something I have never used so I am at a loss.
So, what I need is a SUM (A1:A31 if colour= Red) and SUM (A1:A31 if colour= Blue) etc.
I hope this makes sense or one of you geniuses out there can come up with somethign smart that works better than my idea!
How do I go about formatting selected cells for different colors for each different number in the selected cells? If I have numbers scattered about I want the cell to show a different color depending on the number that is inserted. EG: 115=red, 365=blue.
Trying to format cells b9 through b 24 and cells c9 through c24 to change from white to a light grey color by clicking the mouse button once. so one click white, another click grey. The color grey I need is white, background 1, darker 25% in the autofill field in excel. I have search other forums they all lead to changing the code, I did this already. just copy pasted a code I found but all cells were selected to change a bright green.
I am making some grids which will have a series of numbers in the individual cells. But I can't figure out how to change the colors of the digits. If I change one digit to Red; all the numbers in that cell change to Red. Whereas I would like to have them as Red,Green,Black,Blue,etc.
I have 2 cells (B2 and C2) with date format, showing dates from a calendar. FYI, These cells are NOT in my Calendar.
Now, I need to write a formula for my calendar cells to check these two cells (B2 and C2) and change the color of the cells inside my calendar according to the date sindicated inthese two cells (B2 and C2).
I did this with numbers using conditional formating and it works perfect but doing this with dates is giving me a hard time. Is there a way to do this? below is a link to my excel file.
I am trying to create a formula that looks at a spreadsheet containing training percentages for employees. I need to look at these percentages and based on the date that the person started I need to look at certain rules. First it needs to look at what has happened more recently , moving to a new department or promotion. Next it needs to use that info to decide which rule to use. Ex. the person started 90 days ago then they are subject to rule A. The training percentage then needs to be looked at to see what rating they have. EX. percentage < 90% but > 75% gives a rating of 1. percentage than 50% gives rating of 2. percentage < than 50% rating of 3. Rule B would contain different criteria. My problem is that I tried nesting IF statements but I need more than 7. When I tried to do this in VBA I couldn't get it to work.
Is there any way to have more colors in conditional formatting since it only allow maximum 3 colors. Anyway for your info I have an attendance sheet which I want the data to change colors every time the data is enter as below :-
MC / EL / NS = RED Y = BLUE AL = GREEN OD / RD = YELLOW PH = BLACK
I have read the instructions for conditional formatting and I don't think that is what I need. I have 10 diff year 2005,06,07 etc. I want each cell with with a diff year to turn a diff color. Like I want 2005 to be red and 2008 to be blue.
I have a list of number (these numbers are related to incidents) and I want to use the numbers as a basis to split of the spreasheet by coloring the rows. There is no order to how many of the same number there is. So, what I would like to do is fill rows with a color based on the numbers. For example.
I've worked out the following to change the tab color of a "sub" sheet when data on a master sheet is changed. Could anyone recommend the best way to apply this to multiple sheets (20+) without writing an "if" statement for each "sub" sheet?
Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range) If Worksheets("Sheet2").Range("E7").Value <> 0 Then Worksheets("Sheet2").Tab.ColorIndex = 4 Else: Worksheets("Sheet2").Tab.ColorIndex = xlColorIndexNone End If End Sub
The master sheet is a bill summary where totals are added, if one of the line items is a subcontracted item the total on that particular subs sheet changes from "$0" and i would like the tab color to change on any sub sheet that is affected by the current quantities billed.
I'm trying to have change if the date on it is passed "now()". I am already using the 3 conditional formatting fields and need this one and another one. Here are 2 problems I seem to be having.
First - the code below only works if I change the date on the cell. I want code to either work with Worksheet Active or any other way so the user does not have to redo the date’s everyday. Second - a record might have conditional formatting already. Is it possible for the target cell in this code can show this color while the rest of the row shows the color of the conditional formatting?
Private Sub Worksheet_Change(ByVal Target As Range) Dim icolor As Integer If Not Intersect(Target, Range("G1:G2000")) Is Nothing Then Select Case Target Case Is <= Now() icolor = 39
I have an interesting dilemma. I have Microsoft Excel 2003 and in one workbook I have a choice of certain colors for autofill and for font colors. In another workbook I have a DIFFERENT pallete of colors to choose from. Both workbooks are in excel 2003. Is there a reason why one workbook has one set of colors and another does not? Also, is there a way to change the second workbook so I have the same set of fill in colors in both?
It is working, but the problem It doesn't change the color number automatically after I change the color. There is any way to set up that option so can change automatically?
Function CellColor(rCell As Range, Optional ColorName As Boolean) Dim strColor As String, iIndexNum As Integer Select Case rCell.Interior.ColorIndex Case 1 strColor = "Black" iIndexNum = 1 Case 53 strColor = "Brown" iIndexNum = 53 Case 52 strColor = "Olive Green" iIndexNum = 52 Case 51 strColor = "Dark Green" iIndexNum = 51...................
We use a several Excel files to keep track of who has booked retail space with us. We have a main sheet that has every space within every shopping Mall we deal with. We then have different files for each Mall (this is so we can email the file to the shopping mall to show who is booked in each space but they don't see all the other shopping malls details). We have the other files set-up to read information from the main sheet so when we update a cell with the booked companies name it updates a cell on the relevant file.
This part all works fine, but we also change the booked companies colour depending on if they have they have paid, not paid or awaiting invoice. Currently we change this by hand on the main file then on the other files. I am hoping someone maybe able to explain a way of adding to the formula we already use to update the relevant cells automatically to enable the font (or cell if its easier) colour change to be carried across to the other files.
I'm working with a pie chart that has a dynamic range as its data source and a dynamic range as its legend. The chart shows ratios of bought items depending on customer type. So, when you switch from a "Hair" customer to a "Bath & Body" customer, the ratios shift and the legend changes as well (i.e. "Hair - 25%" to "Hair - 10%").
Is there a way to fix the colors permanently so that as the ranges change, the colors remains the same for each category?
I've seen some VBA for it, but it was for data in long columns, whereas my data is in one range in the middle of the worksheet.
This is probably very simple but I'm having a problem finding how to change the color of a bar based on the value. For example, when the bar reaches 100% I want the bar to turn green while the other bars in the graph stay the same.
when I copy a worksheet from one workbook to another, the colors on the sheet in the destination workbook, become dull/faded. They actually change from the original colors to some off colors. I copy by selecting the source sheet, hold down ctrl key, then drag from one workbook to another). Also, is there a way to get the sheet back to the original colors.
I have rows that contain property identifiers and their owners. One property ID can have multiple owners. I would like to color the rows differently to show each unique property ID with their 1 or more property owners. I have attached a file showing what I would like (with fake data). In excel, I was able to figure out how to highlight the duplicate values, but it only does them in one color. I would like each property ID value to have it's own color - as I show in the attached file. In the file, I have value 1234 as one color, the 4546 values as another color and 2233 values as another.