raihnman
Board Regular
- Joined
- Nov 5, 2002
- Messages
- 99
I am using an IF statement and would like to change the cell color for one condition. Can someone help me?
=IF(E15*1000000000000>1000,"",E15*1000000000000)
(I want to change the blank cell to a new color)
Also, how do I change the font color in a cell using the IF statement.
=IF(E15*1000000000000>1000,"Red text","Green text")
I would like the "Red Text" to be red, and so forth.
Thanks,
Raihnman
=IF(E15*1000000000000>1000,"",E15*1000000000000)
(I want to change the blank cell to a new color)
Also, how do I change the font color in a cell using the IF statement.
=IF(E15*1000000000000>1000,"Red text","Green text")
I would like the "Red Text" to be red, and so forth.
Thanks,
Raihnman