About Us

sldfghtrike

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

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.

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

sldfghtrike

Quote:

Originally Posted by Spencer101

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

No problem, here it is.

Spencer101

Quote:

Originally Posted by sldfghtrike

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.

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

sldfghtrike

Quote:

Originally Posted by Spencer101

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

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.

Not a problem. Happy to help :)

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Conditional formatting size limit	Picman	Excel Discussion (Misc queries)	2	August 10th 09 07:01 PM
Font and Size Disabled in Conditional Formatting ??	monir	Excel Worksheet Functions	6	December 14th 08 06:15 PM
uisng two paramaters for conditional formatting / Limiting screen size	Colin Hayes	Excel Discussion (Misc queries)	4	May 20th 07 05:32 PM
Formatting Bar Size	mariab	Charts and Charting in Excel	2	February 8th 06 05:00 PM
why cant i change font size when i use conditional formatting?	cbwindycity	Excel Discussion (Misc queries)	1	January 6th 05 10:45 PM

Menu

About Us