I have a worksheet that lists tasks in column A, Start in Column B and End in Column C. My goal is to set conditional formatting that will highlight a row with a color for the duration of time indicated by the start and end dates in the row immediately to the right of the task. Those cells would be blank and use the date (M/Y) headers in row 3 going out from D3 to CI3. ( D3 is Jan 2015, E3 is FEB 2015 and so on out to CI3) Essentially a Gannt type chart with only the duration shown on B and C.
I could fill this in by highlighting cells but there are hundreds of tasks in Column A. This excel workbook contains tons of other information that a several people use and this is but one report needed in the workbook. We have people that need to get a visual of overall timeline in relation to other data. Although this would be easy to create in MS Project, I need to keep it in excel.
I have tried all sorts of conditional formatting using greater than and less than formulas with little success
I could fill this in by highlighting cells but there are hundreds of tasks in Column A. This excel workbook contains tons of other information that a several people use and this is but one report needed in the workbook. We have people that need to get a visual of overall timeline in relation to other data. Although this would be easy to create in MS Project, I need to keep it in excel.
I have tried all sorts of conditional formatting using greater than and less than formulas with little success