Sorting by format - is it possible?

  • Thread starter Thread starter Larryq22
  • Start date Start date
L

Larryq22

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
 
You have already done 90% of the work.

Put your conditional formatting formula in column C and then sort A & B & C
by C.
 
Sorry for being dense, but can you explain how to do this? Do I highlight
column C, put the CF formula in the CF dialog box? Then I'm not sure what
you mean by "sort by C".
 
Back
Top