close
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
全站熱搜
留言列表
