title: Conditional formatting multiple rules to single cell
body: <p>I have used one formula to change the font colour if a cell contains the text "complete" &amp; another formula to add a light blue fill to the entire row if the word "odd" appears in a cell which is in a different column to the first formula.</p>
  
  <p>The conditions seem to clash &amp; although I have changed and played with the order of the conditions &amp; checked there is no conflict in the fill/background or the font colour, even when changing the font colour manually again the fill from the second formula returns the font the cell to black although it is set to automatic in the conditional formatting rule with the fill ?</p>
  
  <p>I wonder where i am going wrong as everything suggests the two conditions should work fine together though when the fill is applied the font goes back to black when it should be green ?</p>
  
  <p>Have you any suggestions ?</p>