IF Statement in a macro:

If value in H7 is greater than value in D7, then change cell
background color of H7 to BLUE. If value in H7 is less than value in
D7, then change cell background color of H7 to RED.

If value in H8 is greater than value in D8, then change cell
background color of H8 to BLUE. If value in H8 is less than value in
D8, then change cell background color of H8 to RED.

This should be done for each cell in column H starting from H7 going
down.

I'm trying to include this IF statement in a macro I already have.

Thanks for your help!

Why not already set it up to use conditional formatting? No macro necessary!

"Damil4real" wrote in message
...
IF Statement in a macro:

If value in H7 is greater than value in D7, then change cell
background color of H7 to BLUE. If value in H7 is less than value in
D7, then change cell background color of H7 to RED.

If value in H8 is greater than value in D8, then change cell
background color of H8 to BLUE. If value in H8 is less than value in
D8, then change cell background color of H8 to RED.

This should be done for each cell in column H starting from H7 going
down.

I'm trying to include this IF statement in a macro I already have.

Thanks for your help!