http://i122.photobucket.com/albums/o...e/balances.jpg

So basically I want to highlight from A30 to H55 and make a conditional formatting where it will fill rows based on the date on column C. So, like today (7/20/12), everything should be highlighted from A30 to H45 because those days have passed. Those with todays date should not be filled. Thanks a lot to anyone who can help with this.