The conditional formatting in Excel 2007, is confusing and I cannot get
something to work.

I have an Excel 2007 table in which I want to highlight each row where a
specific test value is found in a cell in that same row. This must apply to
all rows in the table. I will try to demo below:


A B C
1 Tom Fred Jane
2 Angie Fred Peter
3 Fred Angie Anne

I want the whole row to change colour when the cell in column b = Fred. i.e
rows 1 and 2 must be higlighted, but not row 3


I just cannot figure out the formula for the conditional formatting.

Thanks.