text colour in if formula

[baz]

please can you help how do i change the colour of text
=if(d4<d5,''order'',''no'')
when ''order'' is entered i would like it to be in red text
when ''no'' is entered i would like it in blue

_________________
sandy
This message was edited by baz on 2002-02-21 12:54
This message was edited by baz on 2002-02-21 12:54
This message was edited by baz on 2002-02-21 12:55

 

[Steve Hartman]

Use conditional formatting.
Format>Conditional Formatting. Change second box to equals and put order in the next box. Choose format and change the text color to red. Click add and repeat the process for no. Click OK twice and you're done.
This message was edited by Steve Hartman on 2002-02-21 13:01