Threshold of Acceptance?

[Peter]

Not really sure what it really means but I do know what I
want to do! As I enter values into a column I want the
numbers to turn red if they are not within 10% of 970. Is
that easy?

 

[Andy B]

Peter

Looks like you need to use Conditional Formatting. Select the cells (or
column) and go to Format / Conditional Formatting.
Set the cell value is not between 873 and 1067 and then set
the cell text colour to red.

Andy.

 

[Bob Phillips]

Peter,

Same approach but I would use a formula as it make sit clearer what is
happening, and is easier to maintain for that reason

Select all the cells, assuming A1 is the first, go into CF and add a formula
of

=AND(970*(1-10%)<=A1,970*(1+10%)>=A1)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Peter]

Perfect. Thankyou Andy, even my IT department didn't know
how to do that.

 

[JE McGimpsey]

Or, to make it a bit clearer and easier to maintain:


=ABS(1-A1/970)>10%

where the CF is entered in cell A1. Adjust to suit.

This way you can change either the target or the tolerance band by
changing only one number in the CF.