title: crystal report cross tab background color
body: <p>I have a table that looks like this</p>
  
  <pre><code>category | number | month year | Color
  -----------------------------------------------------
  All      |  0.25  | YTD 2017   | 
  Apple    |  1.23  | MAR 2017   | 
  Orange   |  1.10  | FEB 2017   | 
  Orange   |  3.33  | YTD 2017   | green
  Apple    |  2.20  | FEB 2017   | 
  Apple    |  1.11  | YTD 2017   | red
  </code></pre>
  
  <p>I want my cross tab to look like this</p>
  
  <pre><code>       |FEB 2017|MAR 2017|YTD 2017
  -------------------------------------
  Apple  | 2.20   |  1.23  | 1.11 (I want this cell to be red)
  Orange | #.##   |  #.##  | 3.33 (I want this cell to be green)
  All    | #.##   |  #.##  | #.##
  </code></pre>
  
  <p>what I have done so far is to have Color in the summarized fields. </p>
  
  <p>it shows up the value as text. but I can't color it ... this is the formula for crosstab background color</p>
  
  <pre><code>if {table1.SColor} = "Green" then crGreen
  else if {table1.SColor} = "Orange" then crRed
  </code></pre>
  
  <p>screenshot of current state.
  <a href="https://i.stack.imgur.com/LhXyF.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/LhXyF.png" alt="enter image description here"></a></p>