VBA Code for Highlighting Cells based on If then Rules

[SKD7]

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

[k1dr0ck]

try

edited some values to test rules

i think someone can think of a better code in lines of code in '3 :D

Please Login or Register  to view this content.

[SKD7]

Thank you soo much, I will try this out. The rules I posted below are sample, I have about 50 such rules, would you know if I can continue coding the remaining 40 similar to how you have done for the below 9 or is there a max limit?

[k1dr0ck]

im not sure about 50 rules in a single sub is not ideal
maybe breakdown each rule in each sub maybe