In one cell (AA10) my formula counts the empty cells. In another cell my
formula states if(aa10=0, "Check Hrs", #7). What I want to do is when "Check
Hrs" is the answer I need the fonts in red. When #7 is the answer just black.
Is this possible. I am not having much luck.

thanks in advance
scott