Sorting by format - is it possible?
You have already done 90% of the work.
Put your conditional formatting formula in column C and then sort A & B & C
by C.
--
Gary''s Student - gsnu200908
"Larryq22" wrote:
Hello. I used the following formula to highlight numbers in Column B which
were not in Column A: =(COUNTIF($A:$A,B1)=0)*(B1<"")
Now I want to resort the list in B so that the highlighted numbers are at
the top. How can I do this?
Or - if there's a better way, I'm open to that too.
Thanks,
Larry
Lexington, KY
|