Conditional Formatting

Ok what I am trying to do is if a cell contains the letters "C/N", I want the row to turn red. I have got it to work if it only contains "C/N", but I need some help with how to search the cell for the letters whilst using conditional formatting.
Can anyone help?

If you want the whole of row 2 to turn red when B2 contains "C/N", possibly within other text try this.

Select row 2

Use conditional formatting with "formula is" option and the formula

=FIND("C/N",$B2)

choose red pattern

Note: you must have the $ in front of the B to make sure the whole row is formatted

Note 2: The above is case-sensitive so formatting won't be applied if B2 contains c/N or c/n etc. If you don't want it to be case-sensitive use SEARCH instead of FIND

Thankyou! Argh, I've been messing around with that all day