Glad you understand the problem in matching up text (120/80) and testing
individual numeric values in 2 separate columns. In a way that's a better
setup as you can watch either systolic or diastolic separately. Since one
may be within range and the other may be out of range, having them in
separate columns allows you to pinpoint any problem.
If you're interested, I have a couple of files that I created some time back
that allow you to track: blood sugar, blood pressure/heart rate, and weight
in any combination (you can track just bp/heart rate if you desire) and
allows graphing the information over various periods of time - you decide
what period. It also allows tracking of nutrition intake with high
carb/sodium intake flagged. This was developed mostly to assist diabetics in
keeping an eye on things, but as I said, it can be used by others doing just
weight watching or blood pressure monitoring. They also allow you to set
your goals or monitoring points so that when an entry is outside of them it
is color flagged also - and the graphs draw lines across so you can see what
entries fell outside of your monitored values. They're not real pretty, but
they are functional.
There are 2 versions of it: a kind of 'light' version that doesn't have a
tremendous amount of nutrition info in it, and a second version that has
nutrition info for hundreds of food items (especially for fast food outlets),
and has a sheet you can even add your own items to so you can track nutrition
info on the foods you eat at home. Both are in .zip format:
The 'light' version:
http://www.jlathamsite.com/BBR/HealthMonitor.zip
The full version:
http://www.jlathamsite.com/BBR/HealthMonitorLG.zip
A web search for terms like Excel Blood Pressure will return more results
and links to other free downloads of files similar to the one I pointed out
earlier.
