Status is <> Complete and the Need by date is behind todays date then should change symbol to RED
IF the status is not COMPLETE and the need by date is behind todays date would want to have the color be Red. If it is current or in the future of todays date would be Green.
Been striking out... here was my latest try
=IF(Status@row <> "Complete", "Red", "Green"), IF(AND([Need by Date]@row<=TODAY()), "Red", "Green")))
Help Article Resources
Check out the Formula Handbook template!