Lonemascot
New Member
- Joined
- Apr 28, 2015
- Messages
- 14
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.
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.
Last edited:
