# Sort by 2 Colors

1. ## 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

2. ## 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. ## 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. ## 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.

5. ## 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!

##### Users Browsing this Thread

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

#### 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