I have created a worksheet to track training records and requirements. So far, I have been unable to find a way to format the cells to change colour when training validity dates are expired or within 6 months of expiry;
RED - Expired date
ORANGE - Date within 6 months of expiry date
This expiry date is based on the renewal date required for that individual column. Not all training has the same validity date range, so every training has its own timeframe referenced in row 3.
I have done some basic VB coding to allow the grouping and filter features to be used when the sheet is protected. The workbook is attached with the password 123 to unlock.
Thanks for having a look at this. I really appreciate it.
Bookmarks