Can MS EXCEL remove duplicates and separate by color coded items ?

I am NOT technical and have just started using MS EXCEL.

Can anyone PLEASE HELP me:

1. How can I automatically remove duplicates using EXCEL ?
ie the same info input more than once on different lines.
Can EXCEL do this ?

2, I have color coded the text in the certain lines in terms of priority.
can Excel rearrange the data by color ?
If yes, How do I do it ?

I think I have EXCEL '97

Thanks for your help in advance.