So by selecting the entire workbook and clearing conditional format is what you're saying? I tried that and it isn't working. There are no remaining red cells. Also, if I can't count with my function, how can I change it to count?