I know no function can change font color.
If I conditional form. can I select a col and
say col A is an emp. name and then there are sales
figures in b c d ect.

so if a1 emp name is bob and he does not have any sales
figuers in b1 c1 d1 ect. his name will highlight red or something
like that