Excel "IF" function question

[hornet]

Does anyone know if it's possible to add a font colour argument to an IF function? I've got a formula returning either "Negative" or "Positive" based on the values of a range of cells, which from a purely aesthetic point of view I want in different font colours. I could do it manually, but wondered if some sort of condition could be included in the IF statement? For example, IF(E2<0,"Negative",font colour red, "Positive",font colour blue). Anyone got any ideas?

[greenv8s]

You can achieve this with conditional formatting (on the format menu).

[hornet]

greenv8s said:

You can achieve this with conditional formatting (on the format menu).

Sorted! Thanks.