VBA colour cells based on month

[Lonemascot]

Hi everyone. I have a table on a sheet that I want to apply to some formatting to.

RULE 1
where the B column (or table heading = "VAT quarter") has my VAT quarter end dates in. I want to fill the cell colour based on the month of these in the following way:
January = Orange fill
April = Yellow fill
July = Blue fill
October = Green fill

RULE 2:
Yellow fill to all blank cells in columns E8:O (table heading = "Date" through to "Phase allocation")

RULE 3:
Red fill in column X (table heading = "verified") if value equal to "-"

RULE 4:
Red font in column S, U and V if <0 (table heading = "Total", "NET" and "VAT")

RULE 5:
red font in column B and J if duplicate with anything else in same column (table ehading = "absolute" and "unique")

In an ideal world I'd like this macro to run after any update to the sheet but if this causes a bit of a slow down (there are thousands of rows) I suppose it could run every 5 mins or so.

In the past I have used conditional formatting rules but end up with hundreds of rules being created when rows are inserted/copied etc and it gets in a bit of a mess hence why i wanted the VBA route.

Thank you for any help you can provide.