Formula/calculation help for medical charting
 

Hi,

I am trying to develop an anesthesia record chart for the vet clinic I work
at. I have A8 through A15 labeled for time, temperature, heart rate, etc. The
other columns (B8-B15, C8-C15, etc) I have set aside for later entries in the
above categories as we take values every 5 min. or so.

What I would like to do is have a formula that would show numerical values
in red if they are above or below the normal value range (in black). For
instance, a dog's normal temperature can range from 99.5 degrees F to 102.5
degrees F. If it is 98 degrees or 103 degrees I want these values to show in
red.
I would like to do the same with each different row (heart rate, respiratory
rate, etc.)

If somebody could direct me to a tutorial or show me a formula that would do
this that would be great! I'm a newbie to excel and am not sure of my way
around the program yet.

Thanks!

Sonia, LVT

Formula/calculation help for medical charting
 

This might help:

http://www.cpearson.com/excel/cformatting.htm

--JP

On Sep 17, 1:17*pm, SoniaLVT
wrote:
Hi,

I am trying to develop an anesthesia record chart for the vet clinic I work
at. I have A8 through A15 labeled for time, temperature, heart rate, etc. The
other columns (B8-B15, C8-C15, etc) I have set aside for later entries in the
above categories as we take values every 5 min. or so. *

What I would like to do is have a formula that would show numerical values
in red if they are above or below the normal value range (in black). For
instance, a dog's normal temperature can range from 99.5 degrees F to 102..5 *
degrees F. If it is 98 degrees or 103 degrees I want these values to show in
red.
I would like to do the same with each different row (heart rate, respiratory
rate, etc.)

If somebody could direct me to a tutorial or show me a formula that would do
this that would be great! I'm a newbie to excel and am not sure of my way
around the program yet.

Thanks!

Sonia, LVT

Formula/calculation help for medical charting
 

Perfect!!

Thank you very much!

Sonia, LVT

"JP" wrote:

This might help:

http://www.cpearson.com/excel/cformatting.htm

--JP

On Sep 17, 1:17 pm, SoniaLVT
wrote:
Hi,

I am trying to develop an anesthesia record chart for the vet clinic I work
at. I have A8 through A15 labeled for time, temperature, heart rate, etc. The
other columns (B8-B15, C8-C15, etc) I have set aside for later entries in the
above categories as we take values every 5 min. or so.

What I would like to do is have a formula that would show numerical values
in red if they are above or below the normal value range (in black). For
instance, a dog's normal temperature can range from 99.5 degrees F to 102..5
degrees F. If it is 98 degrees or 103 degrees I want these values to show in
red.
I would like to do the same with each different row (heart rate, respiratory
rate, etc.)

If somebody could direct me to a tutorial or show me a formula that would do
this that would be great! I'm a newbie to excel and am not sure of my way
around the program yet.

Thanks!

Sonia, LVT

Formula/calculation help for medical charting
 

Glad to hear it!

--JP

On Sep 17, 4:41*pm, SoniaLVT
wrote:
Perfect!!

Thank you very much!

Sonia, LVT



"JP" wrote:
This might help:

http://www.cpearson.com/excel/cformatting.htm

--JP

On Sep 17, 1:17 pm, SoniaLVT
wrote:
Hi,