Register
Log In
Unanswered
Home
New Member
January 28, 2015
Offline
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.
See AnswerJanuary 18, 2015
Offline
Perhaps the following example will provide a solution for you:
http://peltiertech.com/Excel/C.....Chart.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.
July 16, 2010
Offline
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
Answers Post
Most Users Ever Online: 57
Currently Online:
25 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Akshatraj Adig
Liesie Marais
Moet Lewis
Michelle Anderson
Veronica Gallego
krishnaraj r
Dharan Prakash Mishra
Md. Rahman
Lilian Vo
Jane Kumwenda
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
