ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   if statement to change color of text (https://www.excelbanter.com/excel-worksheet-functions/179981-if-statement-change-color-text.html)

mikesteven

if statement to change color of text
 
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

Gary''s Student

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



All times are GMT +1. The time now is 10:35 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com