Formating Font in a Formuls

  • Thread starter Thread starter Silvanus
  • Start date Start date
S

Silvanus

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?:confused: If so how do I code that into the
formula.

Thanks!
 
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
 
Ron said:
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
Click to expand...

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,
Ro
 
Got it!

I needed to put the actual text that was being returned, not if th
statement was true or false, but what I had the formula returning i
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
 
Back
Top