+ Reply to Thread
Results 1 to 1 of 1

Conditional Format Specific Values On Multiple Sheets Based On Dropdown List

  1. #1
    Registered User
    Join Date
    11-21-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    33

    Conditional Format Specific Values On Multiple Sheets Based On Dropdown List

    I have created dropdowns that triggers conditional formatting of a range of cells. I want to have the conditional formated values within the range selected on the main sheet to be applied to those same values found throughout multiple sheets and have the dropdown list change to reflect the same as the main sheet. Example sheet 1 shows (A6:E6 "steve, jones, 550, pike, jackson") (G6 "BAD") if "steve, jones, 550, pike, jackson" is located on any other sheets, I'd like the conditional format rule applied as well as the dropdown list to change from "GOOD" to "BAD". I've attached a pic to further explain. Thanks in advance to anyone that can help lead me in the right direction.
    Attached Images Attached Images

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Conditional format values in dropdown list?
    By xlepws in forum Excel General
    Replies: 5
    Last Post: 05-31-2013, 10:19 AM
  2. [SOLVED] Conditional Formatting of List based on selections from Dropdown list
    By FoxyPinkChick in forum Excel General
    Replies: 4
    Last Post: 05-31-2013, 03:32 AM
  3. Urgent: Create a Dynamic Dropdown list based on a specific criteria
    By vijaye in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-11-2013, 08:07 AM
  4. Return Multiple Values Based On Dropdown List Selection
    By tigabalm in forum Excel General
    Replies: 5
    Last Post: 04-01-2010, 07:36 PM
  5. dropdown list, multiple sheets, automatic fill
    By roybean in forum Excel General
    Replies: 3
    Last Post: 12-09-2009, 05:39 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