software

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

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

quot;ballastraequot; gt; wrote in message
...
gt;I work in quality and I am trying to wite a certificate that will indicate
gt;if
gt; a product does not meet specifications. The problem that I have is the
gt; product has a min and a max value. Example: min 45 max 78. I would like
gt; the
gt; reuslts section to flag in either bold, itlaic or a color. The result that
gt; I
gt; key in equals the 45 and 78, is good between this range-so I am trying to
gt; set
gt; it up for this example if my test product value is below 45 and/0r above
gt; 78
=IF(AND(A1gt;=48,A1lt;=78),quot;certifiedquot;,quot;not certifiedquot;),format the destination
cell as required
--
paul
remove nospam for email addy!
quot;ballastraequot; wrote:

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

Anne Thanks

quot;Anne Troyquot; wrote:

gt; Try conditional formatting:
gt; Format--gt;conditional formatting
gt; ************
gt; Hope it helps!
gt; Anne Troy
gt; www.OfficeArticles.com
gt; Check out the NEWsgroup stats!
gt; Check out: www.ExcelUserConference.com
gt;
gt; quot;ballastraequot; gt; wrote in message
gt; ...
gt; gt;I work in quality and I am trying to wite a certificate that will indicate
gt; gt;if
gt; gt; a product does not meet specifications. The problem that I have is the
gt; gt; product has a min and a max value. Example: min 45 max 78. I would like
gt; gt; the
gt; gt; reuslts section to flag in either bold, itlaic or a color. The result that
gt; gt; I
gt; gt; key in equals the 45 and 78, is good between this range-so I am trying to
gt; gt; set
gt; gt; it up for this example if my test product value is below 45 and/0r above
gt; gt; 78
gt;
gt;
gt;

Paul Thanks and here is an example of what I have:
Description Measure Min. Max.Result Result Result
Wax Percentage 48.0 78.048.72 78.0 100.0

The min and max are locked and the quot;Resultquot; section is what has to be keyed
in when the data is found. So, this is exactly like it would look like on a
certificate of conformance. Also, I may have many different samples which I
would have to key the results for.

So my excel sheet may look like B9 and D9 for the max and Min and the
results could be F9, G9, H9, I9, etc.

I was able to understand the first part of the formula, but I am still a
little lost when it comes to completing. I think that I would like to see the
ones that doe not meet the spec to bold, italic, boldamp;italic or the cell to
be colored. Trying to figure out which one would look the best when the
quot;Result Data is keyed.

Thanks for any other help.
Vernon

quot;paulquot; wrote:

gt; =IF(AND(A1gt;=48,A1lt;=78),quot;certifiedquot;,quot;not certifiedquot;),format the destination
gt; cell as required
gt; --
gt; paul
gt; remove nospam for email addy!
gt;
gt;
gt;sounds like conditional formatting is what you need
--
paul
remove nospam for email addy!
quot;ballastraequot; wrote:

gt; Paul Thanks and here is an example of what I have:
gt; Description Measure Min. Max.Result Result Result
gt; Wax Percentage 48.0 78.048.72 78.0 100.0
gt;
gt; The min and max are locked and the quot;Resultquot; section is what has to be keyed
gt; in when the data is found. So, this is exactly like it would look like on a
gt; certificate of conformance. Also, I may have many different samples which I
gt; would have to key the results for.
gt;
gt; So my excel sheet may look like B9 and D9 for the max and Min and the
gt; results could be F9, G9, H9, I9, etc.
gt;
gt; I was able to understand the first part of the formula, but I am still a
gt; little lost when it comes to completing. I think that I would like to see the
gt; ones that doe not meet the spec to bold, italic, boldamp;italic or the cell to
gt; be colored. Trying to figure out which one would look the best when the
gt; quot;Result Data is keyed.
gt;
gt; Thanks for any other help.
gt; Vernon
gt;
gt; quot;paulquot; wrote:
gt;
gt; gt; =IF(AND(A1gt;=48,A1lt;=78),quot;certifiedquot;,quot;not certifiedquot;),format the destination
gt; gt; cell as required
gt; gt; --
gt; gt; paul
gt; gt; remove nospam for email addy!
gt; gt;
gt; gt;
gt; gt;
gt;

Responses to your new post in .worksheet.functions:
tinyurl.com/9c4wu
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---