Hello,
I'm trying to setup a spreadsheet where conditional formatting is used to populate a gantt chart based on dates entered. For example, columns A & B are for start / end dates for planning & analysis phase of project. Let's say for example C thru Z represent months by year (i.e., Jan 2009 thru Dec. 2020). I will be tracking by color the timeline for 5 phases (i.e., Planning & Analysis, Design thru Development, Testing, Training, and Implementation).
My problem is that excel 2003 only allows you to create 3 conditional formatting formulas. How do I create something similar to conditiona formatting for my other 2 pheases?
My current conditional formula is "Formula Is" = AND(I$5>=$G7,I$5<=$H7)
G5 / H5 have the start/finish dates to be entered
I5 has the date 1/7/09 (with each cell after +7days).
So when I type in a date in G5 / H5 it automatically populates and shades cells to = what those dates represent --- sort of creating a gantt chart type format.
Configuration: Windows XP Internet Explorer 6.0
Hi Fred,
|
"unlimited conditional formatting" ' code to change cell colours for more than 3 entries for conditional formatting Access conditional formatting a cell with multiple formats Conditional formatting blank formula Conditional formatting excel 2008 mac Conditional formatting flaws duplicate Conditional formatting in excel 2003 is blank Conditional formatting to convert numbers to percent Conditional formatting vba excel 2003 Copy conditional formatting Excel 2007 conditional formating next 3 moths Excel conditional formatting if statement Excel conditional formatting more than 3 Excel conditional formatting, sort Excel countif not equal conditional formatting How to add more than 3 conditional formatting in excel How to copy a conditional formatting rule in to another sheet Openoffice conditional format formula copy to other cells