I have an Excel workbook with two sheets. The “Mark” sheet allows you to capture the names and marks. The “Level” sheet displays the level for the entered mark in the first sheet. The problem I have is that for the rows that have no names the cell is still formatted. It should only do this for rows that have names. See attached file.