fleet spread sheet

[Andy B1963]

Hi guys

Would like some help with this one please

I have a spread sheet/ workbook assisting me with my fleet of vehicles and their varying locations daily that my staff (working different duties) require
However, some days my fleet requirements are greater in some locations than others which in turn then requires me to move vehicles about the area.

I think I need a form of conditional formatting to assist in highlight this

Veh. No.	Duty	Veh. No	Duty
19	0600-1600	27	0600-1600
23	0800-1800	29	0600-1600
45	1000-2000	56	0800-1800
67	1600-0200	66	1000-2000
	1600-0200		2000-0600
	2000-0600
Vehicles Req	4	Vehicles Req	4
Shortage	1

<tbody>
[TD="colspan: 2"]Location 1
[/TD]
[TD="colspan: 2"]Location 2
[/TD]

</tbody>

Can any assist please