Hi there,
I have limited knowledge of using excel for anything more complicated than basic calculations.
Looking to set-up a spreadsheet which notifies if an item is due, over due or nearing inspection based on a specified or current system date.
Something along the lines of
Todays Date: 28th April 2012
Vehicle Reg, Last Inspected on 27th April 2012, Due Inspection on 28th May 2012
If not due the DI cell should be green, if approaching date it should be orange if Due or overdue it should be red.
Is this possible?
Cheers
Ryan
I have limited knowledge of using excel for anything more complicated than basic calculations.
Looking to set-up a spreadsheet which notifies if an item is due, over due or nearing inspection based on a specified or current system date.
Something along the lines of
Todays Date: 28th April 2012
Vehicle Reg, Last Inspected on 27th April 2012, Due Inspection on 28th May 2012
If not due the DI cell should be green, if approaching date it should be orange if Due or overdue it should be red.
Is this possible?
Cheers
Ryan