Color changing of fonts by using the IF function
 

Hello:
My problem is I want to change the font color of a cell if it is above 0. I
know it can be changed by formatting. But i want to know if it can be changed
by using IF or any other function.

Thanks and regards,
Sadat Mainuddin

Color changing of fonts by using the IF function
 

Hi,

Use format-- conditional formatting.

you can just tell it to shade the cell if current cell is greater than 0,
then set the format you want if this is true

"sadat" wrote:

Hello:
My problem is I want to change the font color of a cell if it is above 0. I
know it can be changed by formatting. But i want to know if it can be changed
by using IF or any other function.

Thanks and regards,
Sadat Mainuddin