Forum Discussion
@Combination functions to Grade timelines in Excel Gantt
@members recommendations will be great I have timelines in excel with 3 different dates. Action: I want to be able to grade the timelines to reflect the 2 differences as in line 9 Th...
Hi Mtarler
so this formula gives me the separations =IF(AND(AE$5>=$G9,AE$5<=$H9),"X",IF(AND(AE$5>=$H9,AE$5<=$I9),"Y",""))
I am now struggling to show the cut off to apply to the rows below in the conditional formating. Not sure where I am getting it wrong
I want to format the cells with X different colour and the cells with Y different colour
Sry you've lost me. What do you mean "I am now struggling to show the cut off to apply to the rows below in the conditional formating."
Apologies if i'm not clear
I have 3 dates for my duration
What I want to do is to show the duration for (Start date - Delivery to LOB Date) one colour
and then
(Delivery to LOB date – End Date) a separate colour under conditional formatting throughout the applicable rows- I get all that. I don't understand your statement about "...the cut off to apply to rows below..." and hence don't understand what you are having trouble with in achieving your goal.
It is always much easier if you can attach the workbook or a stripped down version of it.
You indicated that the "x" and "y" formula worked so all you had to do is apply 2 conditional formats to the whole region. 1 for the dark green and 1 for the light green.