title: Highlight Cells Rules Text contains
body: <p>I have the following function =AND(EXACT(B3;F3);EXACT(F3;J3)) which returns TRUE or FALSE.
  I'd like to create a cell rule for coloring red the false and green the true values.
  Trying to use the following code, but not working, what am i doing wrong?</p>
  
  <pre><code>   Excel.FormatConditions fcs = xlWorkSheet.Cells[i,"M"].FormatConditions;
                      Excel.FormatCondition fc = (Excel.FormatCondition)fcs.Add(Excel.XlFormatConditionType.xlTextString, Excel.XlFormatConditionOperator.xlEqual, "TRUE");
                      Excel.Interior interior = fc.Interior;
                      interior.Color = ColorTranslator.ToOle(Color.LightGreen);
                      Excel.Font font = fc.Font;
                      font.Color = ColorTranslator.ToOle(Color.ForestGreen);
                      fc = (Excel.FormatCondition)fcs.Add(Excel.XlFormatConditionType.xlTextString, Excel.XlFormatConditionOperator.xlEqual, "FALSE");
                      interior.Color = ColorTranslator.ToOle(Color.LightSalmon);
                      font.Color = ColorTranslator.ToOle(Color.Red);
  </code></pre>