If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Formating Font in a Formuls
Greetings all hopefully this is a simple question. In an IF function I would like to have the value that is returned when True to be one color (green) and the value returned for False to be a different color (red). I would also like both to be bold. Is that possible? If so how do I code that into the formula. Thanks! -- Silvanus ------------------------------------------------------------------------ Silvanus's Profile: http://www.excelforum.com/member.php...o&userid=29515 View this thread: http://www.excelforum.com/showthread...hreadid=492161 |
#2
|
|||
|
|||
Formating Font in a Formuls
Hi Silvanus,
Not in the formula, but in FormatConditional formatting -- Kind regards, Niek Otten "Silvanus" wrote in message ... Greetings all hopefully this is a simple question. In an IF function I would like to have the value that is returned when True to be one color (green) and the value returned for False to be a different color (red). I would also like both to be bold. Is that possible? If so how do I code that into the formula. Thanks! -- Silvanus ------------------------------------------------------------------------ Silvanus's Profile: http://www.excelforum.com/member.php...o&userid=29515 View this thread: http://www.excelforum.com/showthread...hreadid=492161 |
#3
|
|||
|
|||
Formating Font in a Formula
I believe Conditional Formatting will get you where you want to be: Select the cells FormatConditional Formatting Condition 1: Cell Value is Equal to True ---set font color to green Condition 2: Cell Value is Equal to False ---set font color to red Click [OK] Now just set those cells to Bold Does that help? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=492161 |
#4
|
|||
|
|||
Formating Font in a Formula
Ron Coderre Wrote: I believe Conditional Formatting will get you where you want to be: Select the cells FormatConditional Formatting Condition 1: Cell Value is Equal to True ---set font color to green Condition 2: Cell Value is Equal to False ---set font color to red Click [OK] Now just set those cells to Bold Does that help? Regards, Ron Okay I tried the above and yet the cell remains the same. Let me tell you what I did and maybe you can see where I went wrong. A1 contains my IF function I set the logical test for B1 (example B2=2) The Value returned if True is Yes and the value returned if False is No. I then Selected A1 went to Format = Conditional Formatting and set Condition 1 to: Cell Value Is: equal to: TRUE, (made my choices for font color), then Set Condition 2 to: Cell Value Is: equal to: FALSE, (made my choices for font color), I then hit OK. The text in the cell remains its orginal color. Thanks in advance! -- Silvanus ------------------------------------------------------------------------ Silvanus's Profile: http://www.excelforum.com/member.php...o&userid=29515 View this thread: http://www.excelforum.com/showthread...hreadid=492161 |
#5
|
|||
|
|||
Formating Font in a Formula
Maybe your formula isn't returning a logical TRUE/FALSE. Try this: FormatConditional Formatting Condition 1: Cell Formula is: ="true" Condition 2: Cell Formula is: ="false" Does that fix it? Regards, Ron -- Ron Coderre ------------------------------------------------------------------------ Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419 View this thread: http://www.excelforum.com/showthread...hreadid=492161 |
#6
|
|||
|
|||
Formating Font in a Formula
Got it! I needed to put the actual text that was being returned, not if the statement was true or false, but what I had the formula returning if the statement was true and if the statement was false. In this case Yes and No. Thanks much! Your tips helpd me find the soulution! -- Silvanus ------------------------------------------------------------------------ Silvanus's Profile: http://www.excelforum.com/member.php...o&userid=29515 View this thread: http://www.excelforum.com/showthread...hreadid=492161 |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
how do i remove font from message body html formating? | Sheila | General Discussion | 1 | October 6th, 2005 09:59 AM |
Deleting Old Versions of Fonts | Lana A Li | General Discussion | 5 | September 1st, 2005 09:51 PM |
Default font - possible bulletproof fix in Word 2003 | [email protected] | General Discussion | 0 | January 14th, 2005 09:14 PM |
Changing Font Format from Slide Master Won't Change the Formating of Some Text | Burney Choo | Powerpoint | 1 | November 30th, 2004 05:12 AM |
Formating Font in Mail Messages | Alias | General Discussion | 1 | July 5th, 2004 03:05 AM |