IF function answers

Mar 7th, 2002, 03:38 AM

I have a simple If function formula

=IF(D7<=D6*75%,"In Budget","Over budget")

I wish to change the font color for my answers i.e In budget in green and over budget in red,

is this possible?

Dave Hawley · Mar 7th, 2002, 03:43 AM

Hi

You can use Conditional formatting for this. It's found under Format on the main menu

Mar 7th, 2002, 07:44 AM

Thank you

Mark W. · Mar 7th, 2002, 07:53 AM

Quote:

On 2002-03-07 02:38, Anonymous wrote:
I have a simple If function formula

=IF(D7<=D6*75%,"In Budget","Over budget")

I wish to change the font color for my answers i.e In budget in green and over budget in red,

is this possible?

Another way...

Use =(D7<=D6*75%)+0 and apply the following custom number format...

[=1][Green]"In Budget";[=0][Red]"Over budget"

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

Mar 7th, 2002, 03:38 AM	#1
Guest Posts: n/a	I have a simple If function formula =IF(D7<=D6*75%,"In Budget","Over budget") I wish to change the font color for my answers i.e In budget in green and over budget in red, is this possible?

Mar 7th, 2002, 03:43 AM	#2
Dave Hawley Banned Join Date: Feb 2002 Posts: 1,582	Hi You can use Conditional formatting for this. It's found under Format on the main menu