ExcelBanter - IF statement colored results

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - IF statement colored results (https://www.excelbanter.com/excel-worksheet-functions/89360-if-statement-colored-results.html)

matles007

IF statement colored results

In an IF statement is possible for true and false results to be different
colors?

Ian P

IF statement colored results

Select FormatConditional Formatting. Then select formula from the first
drop down box and then enter your formula and the format you want to apply.
You can then enter another formula to test for the false condition.

HTH

Ian

"matles007" wrote:

In an IF statement is possible for true and false results to be different
colors?

All times are GMT +1. The time now is 04:05 AM.