title: Using IF condition to copy either one cell or another
body: <p>I'm creating a list of sorts where I have two columns, one with an expected value the next with an actual value based on information taken from a dropdown box, so three possible variables. I would like a third column to copy another cell based on the outcome i.e. the copied cell is red with text "failed" if the values do not match and a green cell with text "passed" if the values match.</p>
  
  <p>I have been pointed at conditional formatting but I'm not sure it can do something this complex.</p>