need an answer to flag if it cant fall or exceed 2 values in exce
 

I work in quality and I am trying to wite a certificate that will indicate if
a product does not meet specifications. The problem that I have is the
product has a min and a max value. Example: min 45 max 78. I would like the
reuslts section to flag in either bold, itlaic or a color. The result that I
key in equals the 45 and 78, is good between this range-so I am trying to set
it up for this example if my test product value is below 45 and/0r above 78

need an answer to flag if it cant fall or exceed 2 values in exce
 

use conditional fomratting under format menu. see help

"ballastrae" wrote in message
...
I work in quality and I am trying to wite a certificate that will indicate
if
a product does not meet specifications. The problem that I have is the
product has a min and a max value. Example: min 45 max 78. I would like
the
reuslts section to flag in either bold, itlaic or a color. The result that
I
key in equals the 45 and 78, is good between this range-so I am trying to
set
it up for this example if my test product value is below 45 and/0r above
78