Need help color coding cells based on a numerical range.

I am creating a spreadsheet to track equipment such as forklifts, cranes, excavators, etc. I am trying to build a maintenance log to track when oil changes are due, etc. is there a way to color code the cell based on a numerical value? Example would be: hours of last service at 1200. next service due 1700. can it change color at 300 hrs for yellow and 400 hrs at orange and then red when expires at 500 hrs.? Any help would be greatly appreciated. Thank you in advance for your assistance.


HOURS OF LAST MAINTENANCE LAST MAINTENACEPERFORMED
OIL FILTER AIR FILTER OIL Change PLUGS HYDR FLUID HYDRO FILTER
1200

There are instructions at the top of the page explaining how to attach your sample workbook.

You forgot this:

... and some manually calculated results.

In your case, provide enough rows of dummy data to manually show all case scenarios (colour coding) that you require.

Yes, but what you have provided is of no use. It does not show us what you are trying to achieve. Where is the manual colour coding to show us what you expect that row to look like?

You need at least three rows to demonstrate what you are trying to do.

Excel 2016 (Windows) 32 bit

	A	B	C	D	E	F	G	H	I	J	K	L	M
1	FLEET NUMBER	MANUFACTURER	SERIAL NUMBER	HOURS	ISSUES	HOURS OF LAST MAINTENANCE	LAST MAINTENACEPERFORMED
2							OIL FILTER @ 350	AIR FILTER @ 500	OIL @ 350	PLUGS	HYDR FLUID @ 350	HYDRO FILTER @ 350	FUEL FILTER @ 500
3	JBT-TEL1	CAT	CATTL1055C	1254	HYDRAULIC FORKS WILL NOT RELEASE	1200	1200	1000	1200	700	1100	1100	500

Sheet: Sheet1

Oh! Well, first of all, this is a completely different query and it will require VBA, so I am afraid that I’m going to have to ask you to start a new thread in the VBA section with an appropriate title.

Please mark this thread as solved. Thanks.