Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do i make a date change automatically if i change one before . | Excel Discussion (Misc queries) | |||
How to change the default font and size of "comments"? | Excel Discussion (Misc queries) | |||
Worksheet Row Change event | Excel Discussion (Misc queries) | |||
Time Stamp without change | Excel Discussion (Misc queries) | |||
Change Color on an IF statement | Excel Worksheet Functions |