Sign up  |  Log in

Can Excel sort by color?

Let’s say I have a standard excel sheet with 2000 odd rows of data, and numerous columns, but, certain rows are highlighted differently. Is there a way to sort based upon each rows distinct color?

¯\_(ツ)_/¯ It be like that sometimes.

Excel 2010 can do this. Earlier Excels cannot. 

“Visit the Water Cooler forum on Analyst Forum. It is the best forum.”
- Everyone

ohai wrote:

Excel 2010 can do this. Earlier Excels cannot. 

Wow.. I didn’t even try. Sorry to burden your holiness with such trivial pursuits. 

¯\_(ツ)_/¯ It be like that sometimes.

I don’t understand your reply? He answered the question 

Show down voted post CEO10K-DAY -6 points

rawraw wrote:

I don’t understand your reply? He answered the question 

Are you the guy who downvoted me? Because if so, come the **** on bro (and by bro, I mean never my bro). 

I figured out how to sort by color as soon as I actually tried (because I didn’t prior to making this thread), which is why I sarcastically apologized to the guy on the satirical pillar that he is the God of AF. 

IDK why I’m explaining myself. Now please reinstate my karma - I care about that sort of thing. 

¯\_(ツ)_/¯ It be like that sometimes.

No I didn’t. Someone else is doing that. 

Show down voted post CEO10K-DAY -6 points

rawraw wrote:

No I didn’t. Someone else is doing that. 

¯\_(ツ)_/¯ It be like that sometimes.

Show down voted post CEO10K-DAY -5 points

Y’all are sooooooft!!!!

¯\_(ツ)_/¯ It be like that sometimes.

Hahaha weak ass fooosssss

I love my cheese. I got to have my cheddar.

Show down voted post CEO10K-DAY -5 points

 

Nerdyblop wrote:

Hahaha weak ass fooosssss

They h8 us cuz they ain’t us

¯\_(ツ)_/¯ It be like that sometimes.

and they peanut butter and jealous!

I love my cheese. I got to have my cheddar.

Should’ve been short Boeing and CEO10K AF Karma today

If you're the first out the door, that's not called panicking

Codtrawler87 wrote:

Should’ve been short Boeing and CEO10K AF Karma today

It’s not like I cut my dividend or anything though - and you damn well know I’ll be delivering the facts (earning surprises) in the future. Short squeeze is imminent.  

¯\_(ツ)_/¯ It be like that sometimes.

CEO10K-DAY wrote:

Codtrawler87 wrote:

Should’ve been short Boeing and CEO10K AF Karma today

It’s not like I cut my dividend or anything though - and you damn well know I’ll be delivering the facts (earning surprises) in the future. Short squeeze is imminent.  

Did you ever hear back from that girl who texted you to go out for drinks????  Deetz, nephew!!!!

“Mmmmmm, something…” - H. Simpson

Why does AF hide the down voted comments? Is that supposed to be some safe-space-trigger-warning-bull****? 

If you're the first out the door, that's not called panicking

Show down voted post rawraw -5 points

Codtrawler87 wrote:

Why does AF hide the down voted comments? Is that supposed to be some safe-space-trigger-warning-bull****? 

It’s to eliminate spam and trolls by providing a disincentive. I don’t think it works that way here but I’d guess it does in the actual forums 

breadmaker wrote:

Did you ever hear back from that girl who texted you to go out for drinks????  Deetz, nephew!!!!

We went out for happy hour with some co workers. But it’s a terrible idea for me to pursue it. I’m acting generally disinterested and being friendly with her.

Been talking to this cute little Peruvian gal anyway that I met at brunch. 

¯\_(ツ)_/¯ It be like that sometimes.

lol the olde im not down if ur not down but if ur down im down trick! 

give me the loot!

im living vicariously through you.

anyways as jaimie foxx once said:

https://youtu.be/rfjtpp90lu8?t=165

Blame it on the Goose, gotcha feeling loose
Blame it on the ‘Trón, catch me in a zone
Blame it on the a-a-alcohol
Blame it on the a-a-alcohol
Blame it on the vodka, blame it on the Henny
Blame it on the blue tap, got you feeling dizzy
Blame it on the a-a-alcohol
Blame it on the a-a-alcohol

:( i remember when hypnotiq was the coolest drank in hs

I love my cheese. I got to have my cheddar.