Windows Server Posted 6 hours ago Posted 6 hours ago Hello all, I am in need of an excel formula. I cannot find help on exactly what I am hoping to do, and that could be because I don't know the key words to search it.I have a document where annual tasks were completed, that date was put into an excel sheet. I need those cells to turn green when it's been 6 months from when the task was done and remain green until it turns yellow when it's been 7-9 months from when the task was done, and then it will turn red when it's been 10-12 months since the task was last done. Any help with this is so very appreciated!View the full article Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.