VBA help - date then location on custom entry

I looking to write a vba to enable to following if this is possible?

On each date "07/01/2018" in location A, B or C no more than 4 entries "Bulk" can be entered on the same day - Flag a colour

And on the same day "07/01/2018" in locations A, B C no more than 6 entries "Pallets" can be entered on the same day - Flag a colour

Location A can hold on any one day 4 x Bulk & 6 x Pallets
Location B can hold on any one day 4 x Bulk & 12 pallets
Location C can hold on any one days 4 x Bulk & 6 pallets

In the current sheet there are 29 columns holding data

Here is a non-vba implementation. It uses a helper column since I couldn't get the formula to work inside data validation. I also set up a small Excel Table to contain the maximum number of bulk and pallet you can have in each position.

The formula in the helper column is
=AND(COUNTIFS([Date],B2,[Location],D2,[Types],E2)<=VLOOKUP(D2,Table_Loc,2,FALSE),COUNTIFS([Date],B2,[Location],D2,[Types],E2)<=VLOOKUP(D2,Table_Loc,3,FALSE))

COUNTIFS([Date],B2,[Location],D2,[Types],E2)<=VLOOKUP(D2,Table_Loc,2,FALSE),COUNTIFS([Date],B2,[Location],D2,[Types],E2)<=VLOOKUP(D2,Table_Loc,3,FALSE)) gets the count of Bulks for the date for the location.
VLOOKUP(D2,Table_Loc,2,FALSE) gets the maximum number of bulk for that location.

COUNTIFS([Date],B2,[Location],D2,[Types],E2)<=VLOOKUP(D2,Table_Loc,2,FALSE) is true if the count is less than or equal to the maximum number of bulk.

The other half of the formula is the same logic only for pallets. Both conditions have to be True not to trigger the conditional formatting which is simply: =$F2=FALSE.

This will not prevent bad entries, but it will flag them as they happen. It will also flag those other entries that are causing the condition.