+ Reply to Thread
Results 1 to 4 of 4

Drop Down Menu that Controls CF for Range of Cells

  1. #1
    Registered User
    Join Date
    02-26-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    62

    Drop Down Menu that Controls CF for Range of Cells

    I have a table that consists of around 150 cells. I would like to have a cell, separate from the table, that contains a drop down menu, and from the drop down menu are choices that control the conditional formatting applied to the table. So for example, the drop down menu would have 3 options: highlight green only cells <1 or highlight blue all cells <5, or black out all cells between 0 and .5.

  2. #2
    Forum Expert
    Join Date
    09-20-2011
    Location
    England
    MS-Off Ver
    Excel 2010
    Posts
    2,278

    Re: Drop Down Menu that Controls CF for Range of Cells

    Hello
    If for example your table was the range C2:L16 and your dropdown (<1,<5,0-5) in cell A2. Then select cells from C2 to L16 and apply the following conditonal formatting formulas:

    For the Black fill:

    Please Login or Register  to view this content.
    For the Blue fill:

    Please Login or Register  to view this content.
    and for the Green fill:

    Please Login or Register  to view this content.
    Hope this helps.
    DBY

  3. #3
    Forum Contributor
    Join Date
    03-27-2012
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    154

    Re: Drop Down Menu that Controls CF for Range of Cells

    Hi dompoma,

    Please see the attached file, from what it sounds like, this is what you are looking for.

    Let me know if this is what you were after...

    Thanks.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    02-26-2012
    Location
    San Diego, CA
    MS-Off Ver
    Excel 2010
    Posts
    62

    Re: Drop Down Menu that Controls CF for Range of Cells

    thanks guys, I got it working now.

+ 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