sort by cell fill color

Hello,

I'm working on a new macro that I need to group specific unique characters in column A together and then subtotal them. I'm not sure if this is the best way to do it but I was trying to use conditional formatting to highlight the characters that I need and then sort by cell color and cell values to bring them to the top and then sort alphabetically. When I try to record it to a macro it tells me that it can't identify a header row and ends up not sorting it at all and just subtotals. My data looks something like what I have below.


ya
ya
yl
yl
ya
ya
zp
zp
yb
yb
ya
ya


Basically I need it to look like this

ya
ya
ya
ya
ya
ya
yl
yl
yb
yb
zp
zp

I need everything with a ya and yl brought to the top and sorted alphabetically and everything else just sorted alphabetically.

Thanks

well you could use whatever you are using as a conditional format statement as an =IF() formula in the next column to assign 1's and 2's to the ya and yl and then sort by column B.
If you don't need to group them, you could also use =COUNTIF() to get the subtotals.

That should do it, thanks.