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

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

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

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

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

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