Hoping someone can help me out here. I have a workbook with multiple worksheets and would like the worksheet TAB COLOR to be conditionally formatted due to the contents of the cells in a particular column. (The particular column may be different depending on the worksheet).
For example:
Sheet...
Hi, I am relatively new to Excel VBA and I am trying to create a personal template for my work. I already have the below code to insert a new sheet. But I don't know how to change the tab color based on a fixed cell value.
Sub GenerateConf()
On Error GoTo MyError
Sheets.Add...
Hello, I have been trying to find the answer to this exact scenario for a few days and I cannot find anything that will work.
I am trying to change the color of the Tabs within a workbook that has 50+ worksheets.
The problem that I am running into is I want all the color to be based off...
I've never used macros before but I've tried a few macros I found online to solve and no success so far. Here's what I'm trying to do:
My workbook contains around 20 sheets (tabs). I will choose one to use for this example:
For the sheet (tab) named "Mirador" I would like the tab color to...
I have created a spreadsheet of about 80 or so tabs. On each individual spreadheet, in a specific cell, I have a percentage that is populated. In another cell I have the "IF" formula to populate OFF TRACK or ON TRACK based on what the percentage is. I used this formula in the macro view code...
I have tried to find how to set vba code to check each tab in a workbook when the file is opened each day, and based on some date values and other criteria, change the tab color accordingly. My macro is below, but it isn't working. It is changing some tabs blue, and some red, regardless of the...
Hi, thanks for taking my question - my first post on the site!
I would like the tab colour of one of my sheets to turn yellow only if either B9 or B11 has the word "NO" in it. Both B9 and B11 have drop down selections for either 'YES' or 'NO' - not sure if that impacts the code???
Thanks a bunch!
I am trying to change the color of a tab based on the cell value in B5. B5 is a drop down list using data validation that contains four entries: "Flow Rack" , "Workstation" , "Machine Guarding" , and "Other (custom)". A tab is named after each one of these as well. If someone selects...
Hello,
I have Windows 7 and Excel 2010.
Currently I have a macro which checks two reports against each other to ensure all data is in both reports. If they match, J1 has a value of 0 (or very close, like '8.28003976494074E-09') .
There is a tab for each entity, so rather than having to go...
I am looking to write code that automatically changes the color of a tab based on the color of a specified cell.
The cell color is not static and is set based upon the number of the previous month.
I understand the below code won't execute but it explains what I'm looking to do as simply as...
I searched the site and found the VBA code to select worksheets by tab color. I then added the code to print the selected sheets. However, it's getting stuck on 'Next ws' before printing. Can anyone help with what I'm missing?
The macro is as follows:
Sub SelectByTabColor()...
I often have 2 sheets on a workbook and I usually add color and name that, perhaps like most of us. But I feel that, when you only have 2 tabs (not more), it feels counterintuitive the way Excel (2010) shows you a color-filled tab of the sheet that you're not working on, which makes you feel...
Good afternoon,
I am trying to figure out the VBA code to change the color of an excels tabs in a workbook based on values in sheet1.
For example:
Sheet 1(Intro) has Yes or No values in cells C9 through C15.
If C9 is Yes, then tab for sheet2 (Requirements) should be Red. If no then it...
Hi All,
So I'm new to VBA and started out with the For Dummies book. I've got Excel 2010 and I'm struggling with a loop to change tab colors to color 1, 2, 3, ... of a theme. The problem is almost answered here: Colors question [Archive] - Xtreme Visual Basic Talk
My problem is I looked in...
I am completely new to VBA excel. I would like to change the tab colour in a workbook based on the results of an if statement in A1
Here is what I currently have based on code I got from this site. I have no idea what to change in this code so that it responds to an if statement rather than...
First i would like to thank JoeMo for the following code, but I have questions about it...
Private Sub Worksheet_Change(ByVal Target As Range)
Dim myRng As Range, vRng As Range
Set myRng = Range("C14")
If Intersect(myRng, Target) Is Nothing Then Exit Sub
For i = 1 To myRng.Areas.Count...
I am using an Excel Form, and trying to make the user choose a color for a new tab they are creating. I am currently forcing an input box to pop up when the user adds a new worksheet. The user inputs a name and a new box will pop up asking the user to select a color.
I can get the color box to...
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.