+ Reply to Thread
Results 1 to 5 of 5

Sort by 2 Colors

  1. #1
    Registered User
    Join Date
    11-17-2012
    Location
    Alberta
    MS-Off Ver
    Excel 2007
    Posts
    19

    Sort by 2 Colors

    Good afternoon!

    I have a bit of a complicated spreadsheet that I need some help putting the final touches on. Right now I have it so that if the value in Column Q is 8, it fills the whole row green, if the value in Column Q is 5 it fills blue, if the value in Column O is 120+ it fills red, and if there is anything at all in Column P it fills yellow, in that order. I use this as my base sheet, and copy it and all formatting to 3 other sheets. Call them Base, Red, Green & Blue

    What I would like to have happen after all of this is:
    1)BASE SHEET Filter so that only the No Fill and Yellow rows show, and THEN filter that only if Column O has 60 OR 90 AND Column Q has 1 OR 4.
    2)RED SHEET Filter so that only the Red and Yellow rows show, and THEN filter that if Column O has 120+ days
    3)GREEN SHEET Filter so that only the Green and Yellow rows show, and THEN filter that if Column Q has 8
    4)BLUE SHEET Filter so that only the Blue and Yellow rows show, and THEN filter that if Column Q has 5

    I hope this isn't so overly convoluted that someone out there can help!!

    Thank you
    Attached Files Attached Files

  2. #2
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Sort by 2 Colors

    Yellow is the first conditional formatting rule, not the last.

    You can use this formula in R5:

    =IF(P5<>"","YELLOW",IF(Q5=8,"GREEN",IF(Q5=5,"BLUE",IF(O5="120+","RED","No Fill"))))

    Drag that down column R to show the fill color then just use that column to sort or filter by.

  3. #3
    Registered User
    Join Date
    11-17-2012
    Location
    Alberta
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sort by 2 Colors

    You're absolutely right, sorry.

    And you, sir, are a genius. Thank you SO much, I feel like I've been beating my head against this desk for 3 days now!

  4. #4
    Forum Expert 63falcondude's Avatar
    Join Date
    08-22-2016
    Location
    USA
    MS-Off Ver
    365
    Posts
    6,266

    Re: Sort by 2 Colors

    You're welcome. Happy to help.

    See attachment for this in action.

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    11-17-2012
    Location
    Alberta
    MS-Off Ver
    Excel 2007
    Posts
    19

    Re: Sort by 2 Colors

    I'm definitely good for now I will be doing some tweaking to this workbook over the next couple of months, but hopefully I can figure that out on my own!

+ 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. [SOLVED] When sorting data the customized series colors don't sort
    By Rhene in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 09-05-2017, 08:26 AM
  2. Sort data without it moving cell colors
    By taylorsm in forum Excel General
    Replies: 2
    Last Post: 06-17-2016, 10:19 AM
  3. sort data without it moving cell colors
    By Traymond in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-30-2009, 01:23 AM
  4. Replies: 3
    Last Post: 08-08-2008, 06:12 AM
  5. Complex Chart:Need to have COLORS of BARS stay with designated data when I SORT
    By willandr in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-04-2007, 05:30 PM
  6. Replies: 3
    Last Post: 05-19-2006, 12:40 AM
  7. How to sort rows by Colors
    By Sheikh Saadi in forum Excel General
    Replies: 5
    Last Post: 11-19-2005, 08:25 PM

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