+ Reply to Thread
Results 1 to 4 of 4

Conditional Format a string of cells that begin before today & end after today

  1. #1
    Registered User
    Join Date
    03-21-2007
    Posts
    9

    Conditional Format a string of cells that begin before today & end after today

    Hi everyone,

    1st off, I'm using the Trial version of Office 2007.

    I have a Project Schedule (similar to a Gantt Chart) that inputs a number (1 to 10) into my schedule grid (I6 to AM15) to show the number of days a project will last. Through Conditional Formatting, I have the Schedule showing the Weekends, Todays Date, and Holidays. Now, I want it to show Red (when the project is finished) or Green (if the project hasn't started yet), which it does.

    However, I want a 3rd condition to show Yellow if the project has started but hasn't finished. For example, on Row 6 (Tech 1) Wednesday the 5th through Tuesday the 18th should be Yellow. Right now under that scenario, the days before today are red and the days after today are green.

    I've attached a condensed copy of the Schedule. If you highlight cells I6 thru AM15, you'll see the numbers and if you Page Down, you'll see my Data.

    Any help would be much appreciated!

    Jim
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Hi, Jim.

    You should save your file in a previous version of Excel, so that users without Excel 2007 can help you.

    Jason

  3. #3
    Registered User
    Join Date
    03-21-2007
    Posts
    9
    Your Right Jason,

    New Attachment Saved as Excel 97 - 2003.

    Jim
    Last edited by JDarling; 12-11-2007 at 01:35 PM.

  4. #4
    Registered User
    Join Date
    03-21-2007
    Posts
    9
    Guess it would help if the new file actually got attached.

    Jim
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1