create a google spreadsheet for job tracking

I need a google docs spreadsheet. I have included something I started and how I would like it to look. i need 3 sheets for 3 sales people. There are several features I want included such as: i want a condition where if the follow up date is more than 5 days old it will email that row if possible or the whole doc if need be to the person associated with that sheet as well as myself. also if "status" is on hold, sold, or completed then i do not want that emailed. when the"status" column is set to a selection I want the entire row to change color. I would like the following colors: new=yellow, quoted=orange, follow up =red, on hold = blue, sold=green, and completed=grey. also i would like to know how the info can be triggered. do i have to open the doc each time or can it be set to check the doc each day? Please let me know your thoughts and what the estimated cost and timeframe would be.