January 28, 2015
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.
January 18, 2015
Perhaps the following example will provide a solution for you:
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.
July 16, 2010
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.
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.
Most Users Ever Online: 57
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Dharan Prakash Mishra
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas