Thread: if statement to change color of text
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gary''s Student Gary''s Student is offline
external usenet poster
  
Posts: 11,058
Default if statement to change color of text
1. Select cell A1 and pull-down:
Format Conditional Formatting... Formula Is
=F1=0
and set the font color to red
--
Gary''s Student - gsnu200773


"mikesteven" wrote:

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
Reply With QuoteReply With Quote