HELP...auto-alphabetizing in excel 2007

[revdgonzo]

Hi, new member here...I have 2 problems I can't seem to solve. Problem 1; I want my workbook to automatically alphabetize any time a new entry is made. I have been able to get column A to do this but it only alpha's that column and the associated rows remain where they were. This then creates a situation where the name does not have the correct date associated with it. How do I get it to auto alpha in column A and take all of the entered information in the row with it? Problem 2; I want, say column C, to only allow "today" s date to be entered. ( I have been able to this with data validation) The problem is that I want the column to turn the numbers red when 2 workdays have passed. Also I want the numbers to stay red for only 2 workdays and then turn back to the origional font color. Any help would be greatly appreciated. Thanks.