Can you please advise on the following ,in excel 2007?

Can you please advise on the following ,in excel 2007;
-I wish to enter the date that a vehicle has an MOT in column A;
column B to automatically enter the date that the next MOT is due, twelve months hence (less 1 day of course);
column C to automatically count down the days that are left between MOT’s:
Finally, I want to enable column A to change colour (Green, amber, red) based on the days that are left between MOTs,determined by column C. (e.g.. Green when 364 – 60 days left; amber when 59 – 20 days left; red when less than 19 days left) Can you please advise,
regards,David