ExcelBanter - Color of output

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Color of output (https://www.excelbanter.com/excel-programming/359906-color-output.html)

John[_120_]

Color of output

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

Tim Williams

Color of output

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

All times are GMT +1. The time now is 05:33 PM.