Hi, Attached is the excel data file Updated Data File.xlsx 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