CASE WHEN lower({custbody_comments}) LIKE '%g2g%' THEN '<p style="font-stylebold;background color#08ff00;text-color:#000000;text-align: center;"> Good To Go' WHEN lower({custbody_comments}) LIKE '%*pd%' THEN '<p style="font-styleBOLD;background color#ff8700;text-color:#000000;text-align: center;"> Partial Delivery' WHEN {custbody_delivery_date_schedule} < CURRENT_DATE THEN '<p style="font-stylebold;background color#ff8585;text-align: center;"> DATE IN PAST' WHEN {custbody_delivery_date_schedule} < CURRENT_DATE AND lower({custbody_comments}) LIKE '%g2g%' THEN '<p style="font-stylebold;background color#ff8585;text-align: center;"> DATE IN PAST' WHEN {custbody_delivery_date_schedule} < CURRENT_DATE AND lower({custbody_comments}) LIKE '%G2G%' THEN '<p style="font-stylebold;background color#ff8585;text-align: center;"> DATE IN PAST' END