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