I can format a cell under conditional formatting and it works fine if I just copy and paste something into the range.However when I clear the contents of the cells and input new data the conditional formatted cell rule is deleted as well how can I protect it