Forum Discussion
Excel Formula Needed
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 ann...
Hello,
To color-code task completion dates:
Select the task completion date cells.
Go to Conditional Formatting -> New Rule -> Use a formula to determine which cells to format.
For Green (6 months ago):
=AND(TODAY()-A1>=180, TODAY()-A1<210)
For Yellow (7-9 months ago):
=AND(TODAY()-A1>=210, TODAY()-A1<270)
For Red (10-12 months ago):
=AND(TODAY()-A1>=300, TODAY()-A1<=365)
After entering each formula, click OK. The cells will color-code based on the time passed since task completion.
In some environments, it could be that you need to use ; instead of , as seperator.
Hope that helps!
Good luck and best regards :)