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

"Conker10382" wrote:

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?