Changing text colour via a logical function

**Spudgunner** · 06-01-2011, 12:49 PM

Is there a way to change the colour of a number as a result of a conditional IF statement. Something like this:

IF( C1 > 50, change text colour ("Greater than 50"), "Less than 50")

Result if C1 = 60
Greater than 50
Result if C1 = 20
Less than 50

**mewingkitty** · 06-01-2011, 12:57 PM

Yeah you can go with
if(c1>50,"*","")
and set up conditional formatting so that if the cell contains * then it will change green... or whatever.
Or, by the sounds of it, you want it to output a number, so just use conditional formatting to say if cell value is greater thn 50 - and set the format to red.

**Spudgunner** · 06-01-2011, 01:56 PM

Originally Posted by mewingkitty

Yeah you can go with
if(c1>50,"*","")
and set up conditional formatting so that if the cell contains * then it will change green... or whatever.
Or, by the sounds of it, you want it to output a number, so just use conditional formatting to say if cell value is greater thn 50 - and set the format to red.

Thanks, that'll work