sorting a list
 

please help

i have a list like this

name assessment date to be completed

a n other fda 01/01/06
a body summary 02/01/06
me to otmr 04/01/06 and so on with about 30
other rows

what i would like is the list to automatically put names in date order and
then print the worksheet also when the dates get within 15 days to be
completed the name, assessment and date turns red also if it is within 45
days they turn blue.
now for a little tricky bit i would like there to be a space between each
colour so all the reds are in one block and then a space then all blue

hope someone can help

thanks