Results 1 to 6 of 6

Change sheet tab color based on variable

Threaded View

  1. #1
    Registered User
    Join Date
    11-04-2011
    Location
    Irving, Texas USA
    MS-Off Ver
    Excel 2010
    Posts
    12

    Change sheet tab color based on variable

    Hi! I really need help with changing a worksheet tab color based on a specific variable inside my worksheet. I have attached the workbook. In this workbook, There is a summary page for all open and closed projects. Between these 2 sheets are individual project sheet tabs for each individual project. i would like to be able to automatically change the tab color (light brown color) for each individual project based on row 3, column C , when "Closed" is chosen from the drop down list. I have a "project template" that is used for new projects, but would like this function to be in the already existing projects (263344, 261089, 11-422, etc....).

    Any help would be greatly appreciated!
    Thank you!
    Stacy
    Attached Files Attached Files
    Last edited by excelstacy; 11-29-2011 at 11:25 AM.

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