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