+ Reply to Thread
Results 1 to 2 of 2

Tab Color Macro, Conditional to Cell Value(text)

  1. #1
    Registered User
    Join Date
    04-04-2012
    Location
    Minnesota
    MS-Off Ver
    Excel 2007
    Posts
    1

    Tab Color Macro, Conditional to Cell Value(text)

    I need a macro that will color tabs for me based upon a text value in a cell.

    here's what I have for sheet names.

    Sheet Names:
    Sheet1
    Gregstab
    Mikestab
    Joestab

    I want the Macro to key off a key word, or name in sheet 1, Such as A5

    If A5 = Greg, Color tab Greg turns blue
    Else
    If A5 = Mike, Color tab Mike Turns Blue
    Else
    If A5 = Joe, Color Tab Joe turns Blue.

    Could someone please help me with this?

  2. #2
    Forum Contributor tkowal's Avatar
    Join Date
    11-20-2010
    Location
    Miami, Fl
    MS-Off Ver
    Excel 2010
    Posts
    150

    Re: Tab Color Macro, Conditional to Cell Value(text)

    Here is one way of doing it

    tabcolorchange.xlsm
    Ted
    "Live Long and Prosper"

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1