Hi, a problem came out from the code for Tardy. In the range D13:AB64, there are other codes like "T/O" and "T/I". When I run the macro, the "T/O" and "T/I" were also shaded. I changed the Tardy to Late which was fine, but again there was code "LE" and the macro shaded the "LE". Next I replaced Late to Delayed but it became worse because all the cell areas (lower right) of D13:AB64 were shaded. Please help again.