color change

  1. M

    Double click for changing cell color

    I have this VBA (see below) to change the cell color on a double click. I need to make this so it will change a row of cells with the double click. Any ideas? Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) Cancel = True Select Case Target.Interior.ColorIndex...
  2. O

    Cells that automatically change color

    Hi ! I was wondering if anyone could help me. I have provided an image, so illustrate what I mean. As you will be able to see I have a column labelled PM - this column has the initials of project managers. When I enter the initials it will automatically fill in a color. This has been...
  3. S

    Gantt – color change

    I’m looking for a way to easily see the task overlap per person in a gantt chart. How can I change the colors in the bar chart to match the color of the staff person assigned the task? Or is there a better way to do this? Thanks! Col A = Staff Sam - green Steve - yellow Jon - blue <tbody>...
  4. J

    Set workbook color theme via VBA

    Hello, I was wondering if its possible to use VBA to change the color theme of a worksheet? I am using the code below to create a new workbook and copy worksheets into this workbook from another workbook. Unfortunately, the workbook color theme in my initial workbook is set on "Violet" -...
  5. J

    Active X Button - need to change background color

    Here is the code I have for the Macro, but I am not able to figure out how to change the color of the botton on the worksheet. Can anyone help me fix my code. I am new to Excel: Sub Macro1() ' ' Macro1 Macro ' ' Application.ScreenUpdating = False Sheets("Template-Contact...
  6. J

    Color change on Click using VBA

    I'm attempting to create a worksheet that could act as a test prep. I have the questions in column B in cells 2 to 400 with corresponding 4 multiple choice answers in C2 to F400 and the and the answers in the corresponding rows in column H. My goal would be to have people able to click on the...
  7. G

    Excel Scrum Template

    My issue is a two part question: 1. I found a good scrum template in excel to list the sprint tasks associated with product backlog items. These tasks are color coded by some logic in the background. However, the sprint template only has two colors. If I want to add unique tasks associated...
  8. T

    How to color a cell, by the color next to it.

    I have a long 1000+ row of data that I am checking. My program colors incorrect cells red and blank cells orange. I need to be able to set the colors back to the original values. Is there a way that I could take the color one column (to the left of right) and use it to color the correct cells...
  9. E

    Comparing cells in two excel sheets to see if those cells match and if they do not change their font color

    Hi, I am comparing two long excel sheets that are nearly the same, the only difference is that sometimes some of the cells from one excel sheet gets updated and it is difficult to notice that change in that cell. So, basically I want to check cell values and see if they match, and if not I...
  10. L

    Mac Excel 2004: Comparing numbers across columns, HOW TO highlight lowest number in row by color change?

    *Whew* long title! I'm comparing quotes from suppliers in a table, and want to automatically highlight the lowest quote in each row with a colour change. I'm hoping that there is a formula or formatting that I can use that will do this quickly. Can anyone help? Thanks! Steve
  11. V

    Change Speedometer chart Gauge color based on range

    Hello all, Kindly help me with a small macro or vba script, to change the gauge color based on pointer range value. Here is excel file : http://devserver.swsdreams.com/client/mrexcel/speedometer-final.xls Please see the color range in Ranges column. Is there any way to change the...
  12. E

    Auto Shape color change - conditions met

    :eeek: I have a job status board that I would like to use an Autoshape arrow and have it turn green once 4 checkboxes have all been selected. This is over and above my one line code abilities. I currently am using Excel 2010 and the Active X control checkboxes. Any assistance would be greatly...
  13. E

    Button color and text change on click

    I have created a spreadsheet with command buttons that change color when selected or deselected. I would like to have the text of the commannd button change as well. When the button is green I would like the text to read "YES", when the button is red, I would like the text to read "NO". My...
  14. G

    Changing Text Format with Formula or Conditional Formatting with multiple values

    Hello all! To give you an idea of what I am trying to do, let me break down what I have... I currently have a workbook with multiple spreadsheets used to track requests received, and follow them throughout their life... sort of a "help desk" type of tracker, where we assign a ticket number and...
  15. T

    Cell color transfer

    Hi folks, I'm trying to = a cell fill color from one page in a workbook to another. I've tried to (=) the cell, but I don't get a color. Anybody know the right way to do it? Thank you very much for a reply!
  16. K

    sheet tab color change macro

    Hello, I'm using Excel 2007 and Windows XP Basically I'd like to change or not change the sheet tab color automatically dependent on a cell's content or lack of content. I'm using an IF formula that enters a "1" or it remains an empty cell. I want to change that sheet tab color depedent on...
  17. A

    Drop down applying of conditional format

    Morning all, Got a bit of an odd one, I've had a trawl through the archives and can't find anything quite applicable... What I'm after is a drop down that contains the options:- Live Completed Re-Diarised However, these need to be just the drop down options and independant of the Cell...
  18. R

    Command Button Color Change

    Hello. I have created a model where I have 12 command buttons (one for each month). These command buttons have a macro attached which runs a specific operation for that given month. I would like that when the month is selected, that the button change color- maybe yellow- so that the...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    • Started by ipbr21054
    • Replies: 37
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    • Started by Moeey
    • Replies: 34
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    • Started by AllisterB
    • Replies: 30
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top