How do you sort cell value using conditional formatting?

You can sort and filter by format, including cell color and font color, whether you have manually or conditionally formatted the cells.

NOTE   When you create a conditional format, you can reference only other cells on the same worksheet or, in certain cases, cells on worksheets in the same currently open workbook. You cannot use conditional formatting on external references to another workbook.