I apologise if this has been asked before but i couldnt find what im looking for.
Basically i am looking to create spreadsheets for all my yearly checks. I have 3 columns and upto 100 rows, and i would like the date colums to be on a traffic light system whereby it is green if it is more than 10 months from date trained, to amber for 11 months and red for 11 months 2 weeks
<tbody>
</tbody>1 Steve 1/1/16
2 Jane 1/2/16
3 Gary 1/3/16
I hope i have explained this properly and really appreciate any help i can get with this
Basically i am looking to create spreadsheets for all my yearly checks. I have 3 columns and upto 100 rows, and i would like the date colums to be on a traffic light system whereby it is green if it is more than 10 months from date trained, to amber for 11 months and red for 11 months 2 weeks
Ser. | Name | Date Trained/Refreshed |
<tbody>
</tbody>
2 Jane 1/2/16
3 Gary 1/3/16
I hope i have explained this properly and really appreciate any help i can get with this