color change

Hello all, I am new to VBA and am trying to figure out how to create buttons that perform certain functions. I am creating a product information page that provides specs for a given product. By default, all information should display in English units. In addition, the button "English" under...

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

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

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

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

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

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

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

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

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

*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

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

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

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

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

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!

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

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

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