if statement to change color of text

  • Thread starter Thread starter mikesteven
  • Start date Start date
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
 
1. Select cell A1 and pull-down:
Format > Conditional Formatting... > Formula Is >
=F1=0
and set the font color to red
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to extract separated text by many commas in Excel? 0
Comparing cells and output text 7
'if then' color changes....................... 4
IF Statement based on cell color 2
IF Statement - compare to coloured cell 7
Changing Color of the Cell under Certain Conditions 8
Changing Cell Color Based on Value 2
Multiple arguments 1

Back
Top