Question

Locked

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

By davidkaz ·
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

This conversation is currently closed to new comments.

2 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Answers

Back to Software Forum
2 total posts (Page 1 of 1)  

Related Discussions

Related Forums