if statement to change color of text

M

mikesteven

I need an if statement in cell a1 to change the text to red if cell f1 is
equal to zero. Can you help me?

Thanks,
Mike
 
G

Gary''s Student

1. Select cell A1 and pull-down:
Format > Conditional Formatting... > Formula Is >
=F1=0
and set the font color to red
 
Top