LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Junior Member
 
Posts: 8
Default 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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


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


All times are GMT +1. The time now is 10:35 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"