Changing font color based on content

[ExcelNovice]

How can change I the font color depending on the content of a cell?

Example, I'm using IF statements to determine the content of a cell and want the content to be blank (empty) if one condition is not met.

This is what I have:
=IF(H10<1,"Red alert","empty cell")

But instead of having empty cell displayed, I want the cell to be empty! I know this may be a simple thing, but I really don't know what to do.

Please help.

[crimlet]

On 2002-05-16 06:54, ExcelNovice wrote:
How can change I the font color depending on the content of a cell?

Example, I'm using IF statements to determine the content of a cell and want the content to be blank (empty) if one condition is not met.


This is what I have:
=IF(H10<1,"Red alert","empty cell")

But instead of having empty cell displayed, I want the cell to be empty! I know this may be a simple thing, but I really don't know what to do.

Please help.
TRY =IF(H10<1,"RED ALERT","")

[Von Pookie]

To change the font color, go to Format|Conditional Formatting.

[ExcelNovice]

Thanks all