Conditional formatting

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Automatically Sort Alphabetically 3
sorting data from one table/range to another table/range 1
Identify Duplicates that are not identical 4
Excel Comparing two columns 1
Fonts and Cells 4
Help: Find Matching Cells, If - Then Move Cell With Self 2
Excel Excel Conditional Format 2
Finding duplicate records that are not exact matches but very clos 1

Back
Top