Question

What is the Difference between sorting and conditional formatting in excel

Answer 1

Sorting

You cannot currently sort a cell range based on the conditional formatting, however an alternative is to insert the same condition in the corresponding row or column, so it returns True or False. You can then sort by this row or column.

Conditional Formatting

If a cell has been formatted with Conditional Formatting then using the Color Index of the cell will not work.

The following two properties are undefined when you have applied conditional formatting.

hope u like it

pls mark it as brainliest

Answer 2

In excel sorting means arranging of data according to the ascending or descending order or according to the name, or according to the grade or rank etc.

In excel formatting means giving a special look to the data, by using colour, or changing style of the rows and columns or by giving a border or by creating a shadow or by creating an illusion etc.