More Conditional Formatting in Excel 2007

[Marc]

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.

 

[T. Valko]

Try this...

Delete the current rules you have applied to this range.

Select the entire range A1:C3
Goto Home tab>Styles<Conditional Formatting>Manage rules>New rule>Use 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