View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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