Excel - conditional formating

  • Thread starter Thread starter TomeK
  • Start date Start date
T

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
 
Hi

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

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

Frank
 
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..
 
Strange, works for me.
If you like, just mail me your sheet and i'll have a look at it
Frank
 
Back
Top