Conditional Formatting Question


Good morning,

I have a column within my Project Schedule Management spreadsheet that tracks the "Health" of a task. It currently conditionally formats the color of the "Health" symbol based on the formula:

=IF([Start Date]87 > TODAY(), "Blue", IF(AND([% Complete]87 < 1, [End Date]87 < TODAY()), "Red", IF(COUNTIFS(CHILDREN(), "Red") > 0, "Yellow", "Green")))

Can anyone tell me how to modify the formula to change the color of the health symbol to "Red" when the End Date is within 60 days of TODAY's date?


Best Answer