| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
CF for over/under mean unit
I need some help writng a CF formula, please.
I am trying to identify measurments that are out of tolerance (either over or under) as follows: Cell B16 = 1/2" Cell C16 = 12 1/8" I would like cell D16 to change font (or bacground) color if the measurment entered into cell D16 is GREATER than C16 + B16 OR conversely, LESS than C16-B16. Does this require two separate conditions? I'm stumped...please help! Thanks in advance...as always! |
|
#2
|
|||
|
|||
|
You only need one condition:
=OR(D16C16+B16,D16<C16-B16) HTH Jason Atlanta, GA "marcy" wrote: I need some help writng a CF formula, please. I am trying to identify measurments that are out of tolerance (either over or under) as follows: Cell B16 = 1/2" Cell C16 = 12 1/8" I would like cell D16 to change font (or bacground) color if the measurment entered into cell D16 is GREATER than C16 + B16 OR conversely, LESS than C16-B16. Does this require two separate conditions? I'm stumped...please help! Thanks in advance...as always! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Populate cells with a unit price | Excel Discussion (Misc queries) | |||
| How do I enter a negative number in unit price column? | Excel Discussion (Misc queries) | |||
| How do you display negative numbers in the unit price column? | Excel Worksheet Functions | |||
| can i load full version of excel on to a ipaq unit | Excel Discussion (Misc queries) | |||
| Need help with unit formulas | Excel Worksheet Functions | |||
Linear Mode
