Try conditional formatting:
Format--conditional formatting
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
Check out the NEWsgroup stats!
Check out: www.ExcelUserConference.com

"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