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
Bookmarks