Results 1 to 4 of 4

Macro that links values for conditional formatting from many worksheets to one main sheet

Threaded View

  1. #1
    Registered User
    Join Date
    12-21-2016
    Location
    Sweden
    MS-Off Ver
    v.15
    Posts
    4

    Macro that links values for conditional formatting from many worksheets to one main sheet

    Hello,

    I have a Main sheet that collects the information that i put in dedicated sheets for different projects. These Project sheets have a conditional formatting in form of a red/yellow/green icon that is controlled when to turn the different colors individually with the help of a box (that i call "indicator control") on every project's sheet. I would like the conditional formatting that is on the project sheets to also be on the main page for each of the projects. As i understand the only way of doing this would be with a macro that automatically creates the correct conditional formatting icon and links every project row to the right project sheets "indicator control" - the problem is that i don't know how to write this macro. If any of you have any idea or some other way of dealing with this problem that produces the a similar outcome i would be eternally grateful!

    I included an example with two projects (in reality it's several hundred) of how i want it to look and behave.

    Thanks in advance!

    /Adam
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Compiling cell values from different worksheets to one main worksheet
    By markusvirus in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-30-2016, 02:39 PM
  2. How to combine worksheets into one main sheet using formula
    By gr8rck in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-11-2015, 06:55 PM
  3. Replies: 1
    Last Post: 09-25-2013, 10:05 AM
  4. [SOLVED] Formula to place data from mulitple worksheets into 1 main sheet
    By lindafinlay in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 04-19-2013, 03:07 AM
  5. [SOLVED] Splitting Worksheets from Main sheet into several sheets
    By surk. in forum Excel Programming / VBA / Macros
    Replies: 18
    Last Post: 08-06-2012, 04:57 PM
  6. [SOLVED] VBA to create multiple worksheets, rename, and insert information all off main sheet ...
    By headstrong2740 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-03-2012, 10:24 AM
  7. Replies: 3
    Last Post: 09-30-2009, 10:50 AM

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