Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How do you sort cell value using conditional formatting?

user-image
Question ajoutée par aisha abubakar , Payroll and advances officer , Nigerian National Petroleum Corporation(NNPC)
Date de publication: 2015/05/09
Ma Angelica Arceo
par Ma Angelica Arceo , Office In Charge/ Pharmacy and Office Assistant , PO's PHARMACY Pototan

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

Data sorted and filtered by color with a legend

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.

More Questions Like This