I used the macro recorder to get what I wanted, now trying to shorten and simplify.
I want to sort by all my red cells at the top, then by number descending.
Can't figure out the syntax of the code.
I've never used VBA to sort by color before.
Here's what I've got.