ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   How do I change the color in an IF proposition. (https://www.excelbanter.com/excel-worksheet-functions/7866-how-do-i-change-color-if-proposition.html)

tom

How do I change the color in an IF proposition.
 
I have formatted cells with an IF proposition that returns two different
answers. I want each answer to have a different color. How do I format the IF
formula?


Dave R.

You would select the cells that contain the IF formula, go to
formatconditional formatting and use "cell value is", then select the
format to be applied, and change the color. Do the same for the 2nd answer
but with a different color.



"tom" wrote in message
...
I have formatted cells with an IF proposition that returns two different
answers. I want each answer to have a different color. How do I format the

IF
formula?




Jason Morin

Use Conditional Formatting. See:

http://www.contextures.com/xlCondFormat01.html

HTH
Jason
Atlanta, GA

-----Original Message-----
I have formatted cells with an IF proposition that

returns two different
answers. I want each answer to have a different color.

How do I format the IF
formula?

.



All times are GMT +1. The time now is 07:03 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com