Conditional formatting

H

herb19355

Help... I have a spreadsheet wtih 3 coulmns. The first contains the person's
last name (family name), the second contains the person's first name and the
3rd column contains the person's age. Column A will have many duplicate
entries..... I want to highlight line containing information for the the
oldest person in each family... there are several hundred entries... any
suggestions? Thanks very much
 
B

Biff

Hi Herb!

Select the range to apply the conditional formatting.

Format>Conditional Formatting
Formula is: =$C1=MAX(IF($A$1:$A$5="jones",$C$1:$C$5))
Select your format styles
OK out

If more than one person with the same name are the same
age, all will be highlighted.

Biff
 
Top