1. Click on the Date column to select the whole column.
2. Right click on the selected column to select "Conditional formatting".
3. Click "+ Add another rule".
4. On Format rules, select "Date is between".
5. Enter the formula below for due in a week and click Done.
6. Date is color coded
If you want to color code the task column, it can be code by Custom formula =AND(A2>Today(), A2 <Today()+6) to below:
Have fun on conditional formatting!
No comments:
Post a Comment