CF for over/under mean unit

G

Guest

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formula for Dates and CF Colour then convert to Text 3
SUMPRODUCT and format problems (2) 2
IF statement for time based data 13
conditional format by comparing to current date 6
HttpWebRequest in .NET CF 2.0 - Sent XML File over 34K Corrupted 5
formula for a pension 22
enhanced conditional formatting 13
Cumulative values across different pages 2

Top