Currently, I am using this formula
=IF([End Date]396 < TODAY(), "Red", IF([End Date]396 = TODAY(), "Yellow", IF([End Date]396 > TODAY(), "Green")))
for health status.
What I would like to do is tweak this, so that if a task is less than 75%, and due in 3 days, the ball is YELLOW. Everything else