View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Damil4real Damil4real is offline
external usenet poster
 
Posts: 34
Default Please Help with Macro Code

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!