Excel 2007 script with 6 conditions

[greywolfe]

Hello,

I have been searching all over the net for an example that closely mirrors what I am trying to do and have been unsuccessful getting anything to work so I thought I would ask for some assistance. I am looking to add a script in my workbook that will perform multiple if statements and if any are true it will place a “D” in column A of that row. I currently manually do this process with the use of filters, but thought a script would make my life a little easier.

So if any of the following criteria are true then I would place a D in column A

Criteria 1: IF MRP (Column I) = JH
Criteria 2: IF Lev (Column B) = 2 and UOM (Column L) = #N/A
Criteria 3: IF Lev (Column B) = 2 and UOM (Column L) = EA and BWS (Column K) < 5
Criteria 4: IF Lev (Column B) = 2 and UOM (Column L) = EA and BWS (Column K) < 50 and RTL (Column H) < 16
Criteria 5: IF Lev (Column B) = 2 and UOM (Column L) = EA and BWS (Column K) < 100 and RTL (Column H) < 10
Criteria 6: IF Lev (Column B) = 2 and CTR (Column J) = 228 or 229

I have attached a small sample page that generally shows the layout of my workbook

Lastly and this certainly is not necessary but if anyone likes the extra challenge, It would a huge bonus if I could also tell the script to change the font color to red (for the entire row) if UOM (Column L) contains (M, L, or KG)

I would to thank you guys in advance for taking your time to try and help me with my problem.

[greywolfe]

Does anyone have a suggestion? I don't mind trying to figure out how to write the script myself but could use some direction on where I might find the best reference material.

[watersev]

hi, greywolfe, sort of that, please check attachment, run code "test", hope this helps

[greywolfe]

Watersev,

The script works great. Thank you very much for your help.

[watersev]

if you are happy with help provided please mark the thread as solved (see Forum Rules for details)