Support Board

Date/Time: Sun, 12 May 2024 22:56:34 +0000

Post From: Draw vertical lines at particular dates every year

[2020-04-16 18:58:31] Link To Thread - Link To Post [Go To First Post]
Chris32 - Posts: 50
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