Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old July 8th 07, 07:58 PM posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 487
Default Health chart

I want to have a formula to show when my Blood Pressure is below 90/60 text
red, and when it is too high over 140/90 blue, and normal text when it is not
either.
--
Don
If all is not lost, where is it?

  #2   Report Post  
Old July 8th 07, 08:26 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 396
Default Health chart

Hi

You could use the cell formatting of the cells.

In addition, Format Conditional Formatting is a natural second choice.

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"don" wrote:

I want to have a formula to show when my Blood Pressure is below 90/60 text
red, and when it is too high over 140/90 blue, and normal text when it is not
either.
--
Don
If all is not lost, where is it?

  #3   Report Post  
Old July 8th 07, 08:56 PM posted to microsoft.public.excel.programming
external usenet poster
 
First recorded activity by ExcelBanter: Sep 2006
Posts: 3,365
Default Health chart

The British Hypertension Society has an Excel file available for download
that has some of that in it and also graphs the readings entered into it.
You may want to take a look at it.
http://www.bpassoc.org.uk/informatio...onitors.htm#rr
Within the paragraph on Recording Readings is a link that you can click and
choose [Save] to get a copy for yourself.

"don" wrote:

I want to have a formula to show when my Blood Pressure is below 90/60 text
red, and when it is too high over 140/90 blue, and normal text when it is not
either.
--
Don
If all is not lost, where is it?

  #4   Report Post  
Old July 9th 07, 06:20 AM posted to microsoft.public.excel.programming
Don Don is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 487
Default Health chart

Thanks for your help. I was amazed at the quick response.

I had to separate the systolic and diatolic readings and format each column.
It is not exactly what I want, but I can understand the reasons why I can't
get what I want.
--
Don
If all is not lost, where is it?


"don" wrote:

I want to have a formula to show when my Blood Pressure is below 90/60 text
red, and when it is too high over 140/90 blue, and normal text when it is not
either.
--
Don
If all is not lost, where is it?

  #5   Report Post  
Old April 14th 22, 08:26 AM
Junior Member
 
First recorded activity by ExcelBanter: Apr 2022
Posts: 1
Default Health tips

Yoga is a great way to get fit, relax and improve your life. The benefits of yoga are endless. It can help you with stress relief, it can be used as an alternative medicine for many health conditions, it can help you lose weight, it can help you sleep better at night, it can help you develop strength in your body, it can help you find balance in your life. Read Mo-https://www.artofliving.org/in-en/health-tips

Last edited by Himanshuchauhan : April 14th 22 at 08:28 AM


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Health record Template Pita Excel Discussion (Misc queries) 1 July 16th 08 02:14 AM
health&wealth health&wealth facility Excel Discussion (Misc queries) 0 August 21st 07 12:26 PM
Tracking system of health clinic tlp Setting up and Configuration of Excel 0 June 19th 06 07:16 PM
track Health insurance deductible littlehermit Setting up and Configuration of Excel 0 February 12th 06 03:43 PM


All times are GMT +1. The time now is 01:48 AM.

Powered by vBulletin® Copyright ©2000 - 2022, Jelsoft Enterprises Ltd.
Copyright 2004-2022 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017