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.
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.
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
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.
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!
If so how do I code that into the formula.
Linear Mode
