Formula/calculation help for medical charting

S

SoniaLVT

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Help, I need a formula for work. 2
How do I create the formula for this calculation? 1
Help - Not sure where I should start 7
Help, I need a formula for work. 7
help with vlookup 3
I have my IF formula, how can i change the text colour for eachif??!! help please!! 2
Macro for multiple charting of multiple datasets 1
Array Formula help- Can this be done? 2

Top