text colour in if formula

baz · Feb 21st, 2002, 01:52 PM

please can you help how do i change the colour of text
=if(d4 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 · Feb 21st, 2002, 02:01 PM

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 ]

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Feb 21st, 2002, 01:52 PM	#1
baz New Member Join Date: Feb 2002 Location: sandy Posts: 17	please can you help how do i change the colour of text =if(d4 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 ]

Feb 21st, 2002, 02:01 PM	#2
Steve Hartman Board Regular Join Date: Feb 2002 Location: Houston,Texas Posts: 418	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 ]