Conditional formatting

[FROGGER24]

I would like to use conditional formatting in cell D18. If D18 value is >= +/-0.0050 shade the cell red

 

[jim may]

Is there a base cell(s) to apply the >= +/-0.0050 to?

 

[Fazza]

try selecting cell D18 and then insert the conditional format. Maybe one of these?

=ABS(D18)>=0.005
or
=OR(D18<=-0.005,D18>=0.005)

 

[FROGGER24]

this is my spreadsheet D18:d22 will need the conditional formatting applied

Excel Workbook
	A	B	C	D	E	F	G	H	I
8	DATE:		3/7/2011				mA Tolerance Specs
9	CALIBRATED BY:						Input	Min	Max
10	CAL SPAN		0-25.14" H2O				4.00	3.90	4.10
11							8.00	7.90	8.10
12							12.00	11.90	12.10
13							16.00	15.90	16.10
14	Calibration Tolerance: > = +/- 0.50%						20.00	19.90	20.10
15
16	INITIAL CHART (As Found)					FINAL CHART (As Left)
17	%	INPUT	OUTPUT mA	ERROR %		%	INPUT	OUTPUT mA	ERROR %
18	0	0" H2O	3.90	0.50%		0	0" H2O	4.10	-0.50%
19	25	6.3" H2O	8.10	-0.50%		25	6.3" H2O	8.10	-0.50%
20	50	12.6" H2O	12.09	-0.45%		50	12.6" H2O	12.10	-0.50%
21	75	18.8" H2O	16.09	-0.45%		75	18.8" H2O	16.10	-0.50%
22	100	25.1" H2O	20.09	-0.45%		100	25.1" H2O	20.10	-0.50%
Sheet1

Excel 2007

Cell Formulas
Range	Formula
C8	=TODAY()
H10	=G10-0.005*20
H11	=G11-0.005*20
H12	=G12-0.005*20
H13	=G13-0.005*20
H14	=G14-0.005*20
I10	=G10+0.005*20
I11	=G11+0.005*20
I12	=G12+0.005*20
I13	=G13+0.005*20
I14	=G14+0.005*20
I18	=(G10-H18)/20
I19	=(G11-H19)/20
I20	=(G12-H20)/20
I21	=(G13-H21)/20
I22	=(G14-H22)/20
D18	=(G10-C18)/20
D19	=(G11-C19)/20
D20	=(G12-C20)/20
D21	=(G13-C21)/20
D22	=(G14-C22)/20

 

[Fazza]

Well, select range D18:D22 and then apply the conditional format to the whole range in a single operation. As a cell reference, use whatever cell is active. So, if you're on cell D18, use that in the conditional format formula: if you're on cell D22, use that: Excel will apply it to all the cells in a relative fashion. cheers

 

[FROGGER24]

Thanks for yuor help, I was alble to get your formula to work.

 

[Fazza]

Good work. Have fun. regards