Support Board
Date/Time: Sun, 24 Nov 2024 18:30:24 +0000
Post From: Draw vertical lines at particular dates every year
| [2020-04-16 18:58:31] |
| Chris32 - Posts: 56 |
|
I did learn about alert formulas and successfully used the Color Background Based on Alert Condition chart study. It works except for one thing : the vertical lines that are drawn are not displayed for future dates. For example =AND(MONTH(BARDATE)=10,DAY(BARDATE)=15) will work on the 15/10 every year in the past but not in 2020, as there are is no bar yet. Not sure how to solve this. Date Time Of Last Edit: 2020-04-16 18:58:54
|