Create a job log.

I have some requests about modifying our job log at work. Our company fabricates custom steel assemblies. In our current spreadsheet, each job has a row, and there are 14 columns in each row. One of the culumns is for the job 'Due Date'(column 'D'). I need to, upon entering, atomatically have the jobs be arranged in descending order, by due date, with the jobs that are due soonest listed first. I would also like for the jobs that are due within the current day thru 10 days to be 'red', and the jobs that are due in 10-20 days to be 'yellow'.

Hi and welcome to the board

As you can see here your question has been answered some time ago ( I used the "search" option provided by this forum)

As for the formatting part, try using Conditional formatting

Cheers