Hoping somebody can help.
I am trying to create a spreadsheet that would traffic light each cell based on if a training date had expired/due or was in date.
For example
If A2 was 18/05/15
The cell would traffic light as red as this is over 4 months overdue.
I would like a range of values to be
Green - If this 6 months away
Amber - If this is 2-5 months away
Red - If this is 2 months away or sooner.
I have attached the sheet for somebody to have a look if possible?
I did originally want it on a separate sheet in the workbook but now think that this is pointless and can be done on one sheet.
Thanks
Jon
Bookmarks