Try this...
Formula: copy to clipboard
=LOOKUP(J2,{"Overdue","Red","PastY","Yellow","Green","Complete","No_BL"},{1,2,3,4,5,6,7})