Login Page - Create Account

Support Board


Date/Time: Sat, 17 May 2025 03:27:21 +0000



Post From: Draw vertical lines at particular dates every year

[2020-04-16 18:58:31]
Chris32 - Posts: 61
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