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! |
Please Help with Macro Code
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! |
All times are GMT +1. The time now is 11:55 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com