Conditional formatting a big size

[sldfghtrike]

http://i122.photobucket.com/albums/o274/sldfghtrike/balances.jpg

So basically I want to highlight from A30 to H55 and make a conditiona
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 H4
because those days have passed. Those with todays date should not b
filled. Thanks a lot to anyone who can help with this

 

[Spencer101]

http://i122.photobucket.com/albums/o274/sldfghtrike/balances.jpg

So basically I want to highlight from A30 to H55 and make a conditiona
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 H4
because those days have passed. Those with todays date should not b
filled. Thanks a lot to anyone who can help with this.

Post a workbook rather than an image of one and you'll get a suitabl
solution far quicker

 

[sldfghtrike]

Post a workbook rather than an image of one and you'll get a suitabl
solution far quicker!

No problem, here it is

+-------------------------------------------------------------------
|Filename: example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=484
+-------------------------------------------------------------------

 

[Spencer101]

http://i122.photobucket.com/albums/o274/sldfghtrike/balances.jpg

So basically I want to highlight from A30 to H55 and make a conditiona
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 H4
because those days have passed. Those with todays date should not b
filled. Thanks a lot to anyone who can help with this.

Have a look at the attachment. Is this what you need

+-------------------------------------------------------------------
|Filename: sldfghtrike example.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=485
+-------------------------------------------------------------------

 

[sldfghtrike]

Have a look at the attachment. Is this what you need?

that did it, thank you very much. I looked at the formula and I see wh
your and formula worked. Basically when I tried doing it I was thinkin
of doing some IF statements, could never get it to work

+-------------------------------------------------------------------
+-------------------------------------------------------------------