Highlight cell if value is 1-2,000 less than value of another cell?

[kwindels]

I'm tracking when service is due on a bunch of vehicles and want the current mileage I have listed to highlight orange when almost due.

I have my current mileage in column F and my service due mileage in column D. So when F is between 1 and 2000 less than D, it should highlight orange. In the picture F225 should highlight orange.

I've used conditional formatting to highlight if column F is greater than column D to show when the unit is overdue, just can't figure the formula out for this one.

Any help is greatly appreciated!!

 

[etaf]

when F is between 1 and 2000 less than D,
=AND(D2-F2>=1,D2-F2<=2000)

Book10
	A	B	C	D	E	F	G	H
1				Due		Miles
2				3000		199	FALSE	2801
3				3000		499	FALSE	2501
4				3000		799	FALSE	2201
5				3000		1099	TRUE	1901
6				3000		1399	TRUE	1601
7				3000		1699	TRUE	1301
8				3000		1999	TRUE	1001
9				3000		2299	TRUE	701
10				3000		2599	TRUE	401
11				3000		2899	TRUE	101
12				3000		3199	FALSE	-199
Sheet1

Cell Formulas
Range	Formula
G2:G12	G2	=AND(D2-F2>=1,D2-F2<=2000)
H2:H12	H2	=D2-F2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2:F12	Expression	=AND(D2-F2>=1,D2-F2<=2000)	text	NO

column G and H are just for illustration

 

[kwindels]

when F is between 1 and 2000 less than D,
=AND(D2-F2>=1,D2-F2<=2000)

Book10
	A	B	C	D	E	F	G	H
1				Due		Miles
2				3000		199	FALSE	2801
3				3000		499	FALSE	2501
4				3000		799	FALSE	2201
5				3000		1099	TRUE	1901
6				3000		1399	TRUE	1601
7				3000		1699	TRUE	1301
8				3000		1999	TRUE	1001
9				3000		2299	TRUE	701
10				3000		2599	TRUE	401
11				3000		2899	TRUE	101
12				3000		3199	FALSE	-199
Sheet1

Cell Formulas
Range	Formula
G2:G12	G2	=AND(D2-F2>=1,D2-F2<=2000)
H2:H12	H2	=D2-F2

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F2:F12	Expression	=AND(D2-F2>=1,D2-F2<=2000)	text	NO

column G and H are just for illustration

Thank you so much!! That worked perfectly

 

[etaf]

you are welcome