john3j
07-09-2009, 07:00 AM
I would like to write a subroutine that runs on a particular worksheet called "Invoice Summary". From here, I would like it to find the last row in the worksheet and count up through Column H. The start of the range to be counted starts at H7 and of course ends at whatever the last row is. I would like the code to go through each row and if there is a number greater that $0.00 left in column G then color the cells in column G and H based on the date in Column H.
If the year of the date in column H is equal to 2007 then the color should be light green.
If the year of the date in column H is equal to 2008 then the color should be light yellow.
If the year of the date in column H is equal to 2009 then the color should be light pink.
If the year of the date in column H is equal to 2010 then the color should be light orange.
If anyone could help make quick work of this it would be great!
Thanks
If the year of the date in column H is equal to 2007 then the color should be light green.
If the year of the date in column H is equal to 2008 then the color should be light yellow.
If the year of the date in column H is equal to 2009 then the color should be light pink.
If the year of the date in column H is equal to 2010 then the color should be light orange.
If anyone could help make quick work of this it would be great!
Thanks