Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Returning an answer in an if fuction between two values | Excel Worksheet Functions | |||
How do I add/subtract hours and minutes when some values exceed 2. | Excel Discussion (Misc queries) | |||
how do i sum 2 values that fall between date ranges? | Excel Worksheet Functions | |||
making used values fall from a list | Excel Discussion (Misc queries) | |||
Need totals of values that fall within a given year | Excel Worksheet Functions |