Hello all

I am trying to use conditional formatting to change the colour of a row when text reads "XXXX", easy i know and found how to do it using formulas however i've come across a problem i cant solve myself.


I have a column with text which states text and date for example SENT 1/1/12. When i use the formula =&A1="SENT" it wont change the colour due to the date being in the same cell.

I need the formula to search the cell and change colour if it contains the text SENT but not exclusively. SO the cell could have the text SENT TODAY or SENT YESTERDAY and still work.
I know CF does this with its own- rules cell value contains "XX" - but it wont highlight the entire row when i try this.

I need the entire row to change and not be exclusive for the text i select.

Hope this all makes sense.

Thanks in advance