![]() |
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? |
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? |
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