Thursday, October 12, 2023

To-do List Plugin customization for color coding such as tasks due in 1 week, 2 weeks, etc

 1. Click on the Date column to select the whole column.


image.png

2. Right click on the selected column to select "Conditional formatting".

image.png

3. Click "+ Add another rule".

image.png
4. On Format rules, select "Date is between".

image.png

5. Enter the formula below for due in a week and click Done.
image.png
6. Date is color coded

image.png

If you want to color code the task column, it can be code by Custom formula =AND(A2>Today(), A2 <Today()+6) to below:
image.png

Have fun on conditional formatting!