Hi,

I need the following formula to also include the following if possible - "=IF(M2="Completed","Green")

=IF(M2="","Green",(IF(M2<TODAY(),"Red",IF(M2<TODAY()+3,"Amber","Green"))))

Thanks