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
Hi wetty,
welcome to the forum.
In last part - do you want to clear the formatting or to delete the date itself?
Also, please upload a sample workbook. Thanks.
Regards,
DILIPandey
<click on below * if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Hi wetty
To add 6 months to when the machine passed its test: =EDATE(TheDate,6)
For the conditional formatting rule, assuming the dates are in column A: =AND(A1>TODAY(),A1<+TODAY()+21)
Regards Kevin
Merged Cells (They are the work of the devil!!!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks