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.

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! 

Freedom Data Import demo on importing data from internet data table

Another demo sheet with examples to get all currency exchange rates, major currency exchange rates and specific currency exchange rate is added to the 'Try demo" function. It demonstrated how to get data from an internet table, filter the required data, to a table or to a cell.

Freedom Data Import new function "Try demo"

 A new function "Try demo" is added to menu. User can copy an Expense summary demo sheet and data sheet to try out.

Freedom Data Import system flow diagram

The download count on "Freedom Data Import" has over 100. Thank you to all your download. I created a gif banner to expain how it works.

To-do List Plugin template creation

When user select the plugin function from menu on a blank sheet, the add-on will ask if user want to have a template. If yes, a template will be created with instructions for user to trial.

To-do List Plugin checking updates on adjacent rows

Besides refreshing the row that has been edited, the add-on will also look for 20 rows above and 20 rows below for any updates.

To-do List Plugin sorting sequence configuration

 User can define additional columns as needed. For example, user can add a column for priority. The "Configure plug" function is now having a field "Sort by column letter(s)" for user to sort as required.