Conditional format, filter and validation list maintenance

[gmoney1975]

I have a spreadsheet I am working on for tracking employee performance. I have created drop downs for date, employee name, incident type, description, and manager name. So far so good. I have three things left to do to make it great:

1. I want to add some type of conditional formatting so when the incident is positive it will color the entire row green, and when the incident is negative it will color the row red. Remember I have about 20 different incident types, both positive and negative, in the incident type dropdown.

2. I would like to create filter so I can choose one employee, or a incident type, or date and only see that information. But I don't want to use the standard auto filter as it has too much unneccessary information on it.

3. I currently have the information for the drop downs in a list in hidden cells. So whenever we hire new people we have to unhide that list and add names to the bottom. Is there a way to make an input box for adding data to these drop downs?

Any help you can give on all or some of these topics is greatly appreciated. Even if you know the name of the thing I am trying to do. I assume I may have to get into macros to do this, which is something I have never used. Thanks in advance.