Thread: Formating Font in a Formula

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!

Hi Silvanus,

Not in the formula, but in Format>Conditional formatting

--
Kind regards,

Niek Otten

"Silvanus" <Silvanus.1zs13m_1134138303.6254@excelforum-nospam.com> wrote in
message news:Silvanus.1zs13m_1134138303.6254@excelforum-nospam.com...
>
> 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
Format>Conditional 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

Originally Posted by Ron Coderre

I believe Conditional Formatting will get you where you want to be:

Select the cells
Format>Conditional 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!

Maybe your formula isn't returning a logical TRUE/FALSE.

Try this:
Format>Conditional Formatting
Condition 1:
Cell Formula is: ="true"

Condition 2:
Cell Formula is: ="false"

Does that fix it?

Regards,
Ron

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!