Conditional Formatting Question

Jim Banks

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?

Thanks!

Ray Lindstrom

@Jim Banks,

Try this:

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

BRgds,

-Ray

Ray Lindstrom

@Jim Banks,

Try this:

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

BRgds,

-Ray

Jim Banks

Thanks very much, Ray.

Jim