title: Multi color cell formatting
body: <p>I am trying to have a column of cells fill with one of 3 colors based on it's value in relation to another cell or the sum of other cells.
  Column A, Column B and Column C. Column A is the colored column.
  A to be green if A is greater than B
  A to be orange if A is less than B but A+C is greater than B
  A to be red if A is less B and less than A+C.
  I have tried using standard fill of green with also conditional formatting &quot;use a formula to determine which cells to format 2 color scale but have been unsuccessful.
  I appreciate any help you may give.</p>