Quote Originally Posted by Sgligori View Post
If I knew how to sort based on any criteria I wouldn't ask how to sort based on color.

Does anyone on this forum know how to sort by color?? Red- Yellow-Green?
You may not believe it, but Alan and I are simply trying to help, but I guess you don't see it.

We are simply asking, what is the condition you are using to generate the colors? If you can apply CF to generate the color, you should be able to use that same criteria to create a way to sort.

Example: Let's say Red is generated because column A says "up". Yellow is because column A say "even", and green is column A, "down".

Now you could use a formula in an empty column to say, =LOOKUP(A2,{"down","even","up"},{3,2,1})

This would generate your list to sort, but then again, what do I know. I just come here for free...