Multiple Condition Do Loop

I have spent sometime searching for why this isn't working but to no avail...

What I am trying to do is loop through a column of data until condition 1 is met then check if condition 2 is met 4 cells to the left. Below is the code, if I change the "And" to "Or" it works when either condition is met but if it is "And" it doesn't. Thank you for the help!

Please Login or Register  to view this content.

Hello redpanda,

You need to check that the first condition is true before check the next condition. You will need a nested If...Then to do this. Try this revision.

Please Login or Register  to view this content.