Screenshots attached, showing basic table idea is when column B has a date, column C shows days until that date based on A1 (which is just =TODAY()), and makes the row bold. When column D has a date, the row gets italicized, a strikethrough and font color change.
1. How can I have column C (Days to Target) show no value or be cleared when I have inputted a Done Date (column D)
2. Possible to have a rule sorting the table when a Done Date has been inputted, making completed task rows sit at the bottom?
Thanks for any help!
Bookmarks