Hello,
I use excel 2010 and I have these two formulas,
=AND(NOT($K2= "DHD - On hold per Client"),$M2<now(),$n2>=0,</now(),$n2>$N2>=0<now(),$n2>)</now(),$n2>
=IF(AND(NOT($K2="DHD - On hold per Client"),$N2>=0,NOW()>$M2),1,0)
I can use either to help me highlight overdue assignments. I have...