You'd need to set some conditional formatting on the cell containing the formula.
Or use some event code to make the color adjustment.

Tim


"John" wrote in message ...
Is there a way to program Excel to display an output to an "IF" or "LOOKUP"
command in different colors for different answers? TIA