View Single Post
  #2   Report Post  
Dave R.
 
Posts: n/a
Default

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?