match column value and fill color in the row for the matched cells

Hi,

I've an excel table containing the list of expenditures of employee. I've to sort the table and use different colors for different employee rows.

How can I do this task using formula? Is this possible?

Please see the attached excel sheet for the sample table and desired output.

Thanks!

yes this is possible.

you will use conditional formatting. Btw, what is your consideration why you highlight a column.

do you need excel to sort at the same time put color on each column? if yes, i think Macro will do the work instead of formula.

Thanks and Regards,
Roneil