أنشئ حسابًا أو سجّل الدخول للانضمام إلى مجتمعك المهني.
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.