Excel - conditional formating

[TomeK]

i have table, A1:A10 are names, B1:B10 are years of birth, C1:C10 ar
city of birth
now, i want to (using conditional formating) find all of people who ha
been born in *x* year in *y* city, and paint that whole row i
yellow?

Thank you all

 

[Frank Kabel]

Hi

highlight all rows and enter the following formula in the conditional
format dialog

=AND($B1=x,$C1="y")

Frank

 

[TomeK]

hmm, it keeps reporting that formaula i entered contains error.

i selected rows, choosed "Formula is" on "conditional formating" and i
formula field entered:
=AND($B1=1976,$C1="Wienna")

i have office 2000..

 

[Frank Kabel]

Strange, works for me.
If you like, just mail me your sheet and i'll have a look at it
Frank

 

[TomeK]

well.. here it is, i attached worksheet..

Attachment filename: book2.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=40983

 

[TomeK]

Did you get it?

Thanks