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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks