sure Joshua,so basically we have a calculated custom field called "indicator"
with formula:
IF(({status}="NEW")=true && {DE:NLT}>$$NOW,"blank",IF((({status}="INP" || {status}="BES")=true &&{DE:NLT}<$$NOW),"Green","red"))
I than use column conditional formatting in a very simple way:if "indicator" is...