Mynda, hello, we have been communicating via email. I have tried everything I can think of to include a vertical indicator bar to show today's date. As you can see from the attached sample spreadsheet I am using inrow formula's and conditional formatting. The goal is to make the chart as simple to use as possible.
Perhaps the following example will provide a solution for you:
http://peltiertech.com/Excel/Charts/GanttChart.html
You will see that a "Vert Line" value has been added with either #N/A or zero with that latter being used to show the current date.
Hi Bernie,
Since you weren't clear how you wanted this vertical bar to look I've made some assumptions in the attached file, and below is a link to a tutorial that teaches you how to apply conditional formats using formulas so you can learn and troubleshoot further yourself.
https://www.myonlinetraininghub.com/excel-conditional-formatting-with-formulas
There are a few tricks to highlighting a whole column/row or rang of cells based on the outcome of one formula and they are explained in the post above.
Let me know if you get stuck.
Mynda
Thank you Derek and Mynda, the answers you provided were extremely helpful and helped me solve the problem. Again, thank you for all of your help.
