How to change cell colors when another cell is affected

[samk379]

I'm working on setting up a work order tracking system for a small shop. I was able to get to the point where an order is scanned and then the location is scanned and that data is inputted into a table (the two-column table on the right side of the sheet). I also have another table set up that is a better visual measure of progress. If order THD0001 is at the WELD2 station, for example, the cell at the intersection of the THD0001 row and the WELD2 column fills green. Right now, when the order moves along to the next step, it blanks the previous cell and fills in the cell of the new location. Is there a way I can make it so that the previous cell fills in black so that we could see which orders required which steps? In other words, if the order goes from WELD2 to ASSEMBLY, the cell for WELD2 is filled black.
I am also wondering if there is a way that when an order is scanned as complete, the date and/or time of that scan shows in the COMPLETE column, but this is less important to the system function.

Any help would be greatly appreciated, thank you!

Work Order Status Sheet.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V
1	Barcode Reader
2
3	Order
4	Location
5
6
7		Order	Date	Due Date	DEBURR	CNCPLASMA	PRESSBRAKE	SAW	LATHE1	LATHE2	MACHINING	DRILL	TACK	WELD1	WELD2	GRIND	PAINT	ASSEMBLY	COMPLETE		Order	Location
8		TFD0012																			TFD0012	CNCPLASMA
9		CHD0036																			CHD0036	SAW
10		GD0009																			GD0009	MACHINING
11		LE0012																			LE0012	DEBURR
12		HK0001																			HK0001	DEBURR
13		THD0001																			THD0001	WELD2
Reader

Cell Formulas
Range	Formula
B8:B13	B8	=U8

Named Ranges
Name	Refers To	Cells
Orders	=OrdersTable[Order]	B8

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
E8:S1612	Expression	=VLOOKUP($B8,$U:$V,2,0)=E$7	text	NO
E8:S1612	Expression	=COLUMN()<MATCH($V8,$A$7:$S$7,0)	text	NO

 

[Jeffrey Mahoney]

Payment, well, let me see. Yes, try to have a happy life.

I'm glad it worked for you.

 

[Jeffrey Mahoney]

Oh, and mark my post as the solution

 

[samk379]

Just did. Thank you very much once again for all your help!