tab color

  1. D

    Conditonal Format Tab Color Depending On Contents of a Column

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

    Excel VBA to Add New Sheet then Change Name to Current Date and Tab Color

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

    Changing Tab color based on the value from one cell

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

    Change tab color based on text within worksheet

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

    How to have your spreadsheet tabs change different colors automatically

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

    VBA to Automatically Change Tab Colors Based on Worksheet Data

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

    Change tab colour based on text in different cells

    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!
  8. S

    VBA Code For Changing Tab Color Based On Cell Values In Drop Down List

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

    Change Tab Color Based On One time Cell Value

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

    Set tab color based on defined cell color

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

    Help with selecting worksheets by tab color and then printing

    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()...
  12. T

    If you only have 2 sheets (2 tabs) in Excel 2010, default display seems counterintuitive. Way to fix?

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

    Change Tab color to Red based on values in first sheet

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

    Property ThemeColor Type Mismatch

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

    Excel VBA tab colour automatically changes - controlled by if statement

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

    VBA to change Tab Color

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

    Tab Color Choice From Form

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

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top