I am creating a spreadsheet to hold information about training qulaifications and important documentation, all which have expire dates. I am looking for a way in which I can have the cells which hold the expire dates change colour to orange two weeks before the actual expiry date and then turn red when the date does expire. I have basic Excel skills so replies with step by step help would be very much appreciated.![]()
Bookmarks