Okay so I totally took the long way on this one. I just realized that you pretty much want to format any cells that contain a number in column B through G with the green background.
Below is the code that should accomplish this for you.
To insert this code press Alt+F8 on your keyboard. Clear the macro name box and type ColorGreen in the box. Select the create option. Then in between the Sub ColorGreen() and End Sub copy and paste the above code.
Close out of the Visual Basic Window and then press Alt+F8 again. This time select the Color Green option and then select Run.
Let me know if this works for you!
Thanks!
Bookmarks