ExcelBanter - Conditional formatting a big size

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Conditional formatting a big size (https://www.excelbanter.com/excel-worksheet-functions/446631-conditional-formatting-big-size.html)

sldfghtrike

Conditional formatting a big size

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.

Spencer101

Quote:

Originally Posted by sldfghtrike (Post 1603846)

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

sldfghtrike

1 Attachment(s)

Quote:

Originally Posted by Spencer101 (Post 1603849)

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

No problem, here it is.

Spencer101

1 Attachment(s)

Quote:

Originally Posted by sldfghtrike (Post 1603846)

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

sldfghtrike

Quote:

Originally Posted by Spencer101 (Post 1603863)

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 why your and formula worked. Basically when I tried doing it I was thinking of doing some IF statements, could never get it to work.

Spencer101

Quote:

Originally Posted by sldfghtrike (Post 1603880)

Not a problem. Happy to help :)

All times are GMT +1. The time now is 09:55 AM.