VBA Code for Highlighting Cells based on If then Rules

Hi, Attached is the excel data file for which I need to create a visual basic code with the following rules.

1. If AssetCondition=Good and ReviseRul=0 and RULCalculated<=10, highlight all 3 cells.
2. If AssetCondition=Good and ReviseRul=1 and RULOverride<=10, highlight all 3 cells.
3. If Priority=Priority 1 and Level 5 does not include any of the following words=UPS, Emergency, Fire, Annunciation, Generator, Sprinkler, highlight both cells.
4. If RULCalculated!=YearinService+EUL-Current Year, highlight all 3 cells.
5. IfUnitCost field is blank, then highlight that cell.
6. If Manufacturer field is blank, then input "Not Visible" in cell
7. If CapacityUnitOfMeasure=numeric value, highlight cell.
8. Update all cells in PlanType column as capital letters.
9. If YearManufactured contains comma then highlight cell.

Can someone please help me write this rule. Thanks in advance