Hello,
I'm trying to write a code that highlights cells greater than 45 min ( in hh mm ss format) in red for a range (C1 to c100) if the corresponding cell b in each row is not equal to 'abc'. It will start from B1 and if B1<> abc highlights values > 45 min, moves to next row, it won't highlight if the cell b is abc and moves to next. Preferably I would need a do loop while cell b<> abc but I know it can be written with for loop as well.
I would appreciate your help
Sincerely,
S.A
I'm trying to write a code that highlights cells greater than 45 min ( in hh mm ss format) in red for a range (C1 to c100) if the corresponding cell b in each row is not equal to 'abc'. It will start from B1 and if B1<> abc highlights values > 45 min, moves to next row, it won't highlight if the cell b is abc and moves to next. Preferably I would need a do loop while cell b<> abc but I know it can be written with for loop as well.
I would appreciate your help
Sincerely,
S.A