Hi,
I am setting up a maintenance schedule as part of our compliance with PUWER. I have set up an Excel sheet with the dates of the latest maintenance completed on each of our machines. I now need to 1) Add 6 months on to each date and 2) use the conditional formatting tool to ensure that each cell turns yellow 3 weeks before the planned date and then after this date goes back to being clear..
Cheers Chris
Bookmarks