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?

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?

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?

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?