Conditional Formatting - using multiple formulas

Hi,

I've recently used a similar solution but have come across a new issue.

I have used one formula to change the font colour if the cell contains the text "complete" and 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.

The conditions seem to clash and although I have changed and played with the order of the conditions and 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?

I wonder where Im 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?

Have you any suggestions?

Hi,

I've recently used a similar solution but have come across a new issue.

I have used one formula to change the font colour if the cell contains the text "complete" and 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.

The conditions seem to clash and although I have changed and played with the order of the conditions and 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?

I wonder where Im 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?

Have you any suggestions?