Hello Mr. Excel community and thank you for your help! You all are always teaching me new things thank you.
I have a validation drop down list on sheet 2, with the original list on sheet 1. The list on sheet 1 has a specific fill color based on the name of the item.
How can I make it so that...
Hello all,
I'm a bit stumped with this. I am trying to create a macro that when I click on a button the fill color will change to yellow (or orange, or red, etc) I am not trying to change the fill color of an object or a specific cell, I just want to change the fill color so that I can click...
Hi,
I'm looking for a UDF that acts as a SUMIFS formula but allows for fill color to be one of the criteria.
I've found many working examples of SUMIF type formulas that use the fill color as the only criteria.
In my instance however, I need a SUMIFS because I have additional criteria (i.e...
I created a program that works in Excel 2007 and 2010, but there is one sub that I cannot get to work in 2013 which does the following:
When there is a picture on the sheet (top left at cell AA1)
Set the cursor position onto a specific pixel location
Get cursor position
Get pixel color at that...
Hey,
I was wondering how to set the fill color in a range("A2:C2") based on what C2 said(e.g-"Yes"). I know how to do this step..
If Sheet1.Range("C2") = "Yes" Then
Sheet1.Range("A2:C2").Interior.Color = RGB(0, 176, 240)
Sheet1.Range("A2:C2").Font.Color = RGB(0, 51, 0)
End If
It's...
How Do I create 2 separate independent (Fill Color) buttons?
I need to highlight hundreds of indepentant excel cells and conditional formating isn't what I need to make this work. I just use the (Fill Color) button and it works great. However it slows me down having to switch different colors...
In cell A1 i have a drop down list with conditional formatting in place. Depending on the value i select, the cell A1 will change fill color. I want cell B1 to change fill color to match the fill color in A1.
Simple example: say i select value 1 for cell A1 and the fill color in A1 goes to...
I converted an Excel spreadsheet to the open source LibreOffice and Open Office. As a result, it changed many of the fill colors from clear/white to red. I did not want this to happen. Now I am back to using MS Excel 2013. How can I easily change the fill color red back to fill color white...
hello, i dont know much about VBA coding but if anyone is willing to help, i run a predictions league and i would like to be able to make a code so if the home teams scores 1st and the person who predicted the result put the home team to score 1st too, i get a value of 2 points, if the results...
Hello everyone,
I am familiar with a few coding languages, including PHP, C++, etc, however I am new to Excel and VBA. I am attempting to create a do-while/do-until loop which stays in the same column, and keeps descending row to row until it hits a Gray-filled cell, at which point it takes...
I'm working on a macro that will format a chart so that it will look the same as all of my other charts.
Getting the code set up for my XY Scatter charts has been causing problems. I've been recording keystrokes and then building the code from there. The issue I'm working on right now is this...
Hi,
I'm looking for a way to gradate the fill color of a cell according to 5 intervals of values listed in another cell. The intervals are 1, 3, 4 to 14, 15 and 25. These interval would translate to a color ranging from dark green to bright red.
I know conditional formatting can change the...
When "No" appears in a cell of a dynamic range I set the fill color to red in vba. A macro gives the option of hiding/unhiding the column containing this range. On unhiding the column, red is gone. How do I preserve the fill color without having to go through the range cell-by-cell on...
Is there a way to transfer conditional formatting across sheets in a workbook by referencing the cell?
I have a large workbook that has Mon-Fri calendar schedules showing when employees are working. The Master Calendar tab is where we edit content and apply different colors to the cells so...
I'm somewhat of a newbie at working with VBA code. I have a workbook where the users can edit cells that have a fill background of "rose". When they clear the field and enter a new value then hit "enter", the color changes to blue and a message box pops up. However, I have to assume that the...
I have a large workbook with a pivot table on every worksheet. The pivot tables are very similar to each other, and for the most part use the same fields, they just have different data selected.
The problem: I have to go through the entire thing and add fill color to certain fields, in order to...
I have a large workbook, with similar pivot tables on every sheet. Some rows of the pivot tables have fill color. I need to loop through the workbook and make these fill colors consistent.
I set about doing this by recording a macro of myself putting in the fill color for one particular type of...
I have tried understanding other threads that have similar problems with cell's fill color, but for the life of me I just can't understand them so time to get help with people who actually dominate coding and Excel. This is something that looks simple in my mind, I just have no idea how to...
Hello.
I use Excel daily but will admit I never have the need to write codes or even use macros. However, we now have a shared workbook with about 70 sheets (these represent each employee). The workbook is basic and worked well last month.
I recreated it this month and it's not so smooth...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.