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.

Try this...

Delete the current rules you have applied to this range.

Select the entire range A1:C3
Goto Home tabStyles<Conditional FormattingManage rulesNew ruleUse a
formula to determine which cells to format

Enter this formula in the box: =$B1="Fred"
Click the Format button
Select the desired style(s)
OK out

--
Biff
Microsoft Excel MVP


"Marc" wrote in message
...
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.