Sorting by format - is it possible?
 

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

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

Sorting by format - is it possible?
 

Rather than a CF, create a helper column with that same formula. Then sort by
that.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"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

Sorting by format - is it possible?
 

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".

"Gary''s Student" wrote:

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