custom sorting and color coding

[hugobosstfs]

I use excel to keep a list of quotes all day. I am wondering if when i enter a new number if the cell can change colors (based on the contract) and be automatically sorted in the list alphabetically.

Thanks