A few If Statements
Posted on 2013-05-10
I am terrible with if statements, and have a need a sub with 4.
On active tab and starting in row 3.
If column E and column AJ equal each other, move to the next row do nothing.
If column E has anything in it and column AJ is blank, of that row turn column C thru E green.
If column E is blank and column AJ has anything in it, of that row turn column AG thru AJ red.
If any red cells (column AJ) = green cells (column E) , delete the green row, and turn the red one yellow. Need to do a top down search of column E
If column E and column AJ are both blank? Home cursor and stop sub.
Looking assistance i writing this sub.. Thanks. -R-