Change Color in a Formula

[Guest]

I wonder if anyone can help me out with this. I have a formula that displays
"Paid" in cell B3 if an "x" is entered in cell A3, and "Unpaid" if no "x" is
present. Just as an added bell and whistle, I'd like the "Paid" to display
in blue and "Unpaid" to display in red. Is this possible?

 

[Guest]

Take a look at Conditional Formatting - that should achieve what you want

 

[edcosoft]

Use the Format menu / Conditional Formatting in cell B-3 ,change to
"formula is" and put the following in the formula box =A3="X". For
formatting choose Font color Blue. You can either make a second
conditional Format at the same time to format font Red if the formula
is =A3="". Or, instead of the second condition, just permantly
format the Font as red.

Alternativly you could leave the "value is" and make it "equal to"
"Paid" and the format Font Blue, and the second Condition is "equal
to" "Unpaid" with format Font Red.


ed