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
Bookmarks