CF a record instead of a single field

[Cazito]

Is there a way of conditional formatting all the fields of a specific record based only on the conditions of one single field of that record?

Example:

Suppose I generate a report with a list of employees with fields like name, address, date of birth, etc...

1) John Doe - Poker Street - Chicago - 10/11/1952

2) Mary Lou - Chess Street - Washington - 9/15/1963

3) Mark Jones - Domino Avenue - Chicago - 7/22/1971

Suppose I want to highlight all the employees born in Chicago in my report by making the font bold for these employees. I can easily make the text "Chicago" bold by conditional formating it. But is there a way to format the whole line (including name, adress, etc...) instead of only the city field?

Instead of this:

1) John Doe - Poker Street - Chicago - 10/11/1952

2) Mary Lou - Chess Street - Washington - 9/15/1963

3) Mark Jones - Domino Avenue - Chicago - 7/22/1971

I want this:

1) John Doe - Poker Street - Chicago - 10/11/1952

2) Mary Lou - Chess Street - Washington - 9/15/1963

3) Mark Jones - Domino Avenue - Chicago - 7/22/1971

Thanks in advance.

Sorry for my limited English.

[David Jondreau]

Yes. Simply select all the fields and choose conditional formatting and set up the calculation and the result.

[TheTominator]

To elaborate on D J's concise answer...

Instead of using "Self" in the calculation to refer to the field's contents, use the field name directly, e.g. City.

City = "Chicago"

Use this same calculation formula using City on the other fields too. They can each change based on the value of the City field. Conditional formatting is not limited being based on the value of the field you are formatting.

Edited March 20, 2010 by Guest

[Cazito]

Thanks DJ and TheTominator. Worked beautifully. I love you guys.