Hello All,
I need to format a cell based on the contents of the cell, for example the cell contains the following text:
ONE/TWO/THREE/FOUR
Easy enough to use conditional formatting by matching one word - the cell will higlight green if it contains the word ONE and it will highlight red if it contains the word THREE
But I also need to match on two of the words - so the cell will highlight orange if it contains the word ONE and the word THREE
I have found several formulas for use within conditional formatting, none of which seem to do what I want
Can anyone suggest a formula I could use in conditional formatting to make the above work?
Thanks in advance for any suggestions
I need to format a cell based on the contents of the cell, for example the cell contains the following text:
ONE/TWO/THREE/FOUR
Easy enough to use conditional formatting by matching one word - the cell will higlight green if it contains the word ONE and it will highlight red if it contains the word THREE
But I also need to match on two of the words - so the cell will highlight orange if it contains the word ONE and the word THREE
I have found several formulas for use within conditional formatting, none of which seem to do what I want
Can anyone suggest a formula I could use in conditional formatting to make the above work?
Thanks in advance for any suggestions