Sort by Color in Excel

Sort by Color in Excel in Hindi

If you have manually or conditionally formatted a range of cells or table column, by cell color or font color, you can also sort by these colors. You can also sort by an icon set created through a conditional format.

  1. Select a column of data in a range of cells, or make sure that the active cell is in a table column.
  2. On the Data tab, in the Sort & Filter group, click Sort.
  3. Under Column, in the Sort by box, select the column that you want to sort.
  4. Under Sort On, select the type of sort.
  5. Under Order, click the arrow next to the button, and then, depending on the type of format, select a cell color, font color, or cell icon.
  6. Under Order, select how you want to sort.
  7. To specify the next cell color, font color, or icon to sort by, click Add Level, and then repeat steps three through five.
  8. To reapply a sort after you change the data, click a cell in the range or table, and then on the Data tab, in theSort & Filter group, click Reapply.