Mac Help Forums


Reply
 
New Member
Join Date: Oct 2010
Posts: 3
 
      1st November 2010
I have two spreadsheets of people's contact information. List A includes some people who are also on List B.

Is there a function where Numbers can automatically highlight the names on List B that are also on List A?

Thanks so much for any help.
 
Reply With Quote
 
 
 
 
New Member
Join Date: Oct 2010
Posts: 3
 
      1st November 2010
Problem solved

Got an answer on an Excel forum that worked (in Excel), if anyone's interested:

Select column B and go to Format|Conditional Formatting, choose Formula Is and enter formula

=MATCH(B1,A:A,0)

Click Format and choose colour from Pattern tab.
 
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbers formulae Frank Apps 2 19th April 2011 12:33 PM
Numbers -- hal-l-l-p-p-p! Melba's Jammin' Apps 11 26th June 2008 02:40 PM
Numbers Ian Robinson UK Macs 14 23rd February 2008 06:18 PM
Numbers question Jim UK Macs 1 21st August 2007 10:30 PM
IP numbers Peter UK Macs 4 8th July 2003 01:14 PM


All times are GMT +1. The time now is 12:50 AM.
Mac-Help.com is an independent website and is not affiliated with Apple Inc.


Welcome!
Welcome to the Mac Help Forums
 


Latest Threads
Using Terminal to move my iTunes and GarageBand libraries to an external?
corbytender (1 Hour Ago, 10:51 PM)

itunes message
leondpap (4 Hours Ago, 08:12 PM)

Excel
Shell (6 Hours Ago, 06:46 PM)

how do you carry your MacBook?
SwampWitch (6 Hours Ago, 06:39 PM)

Macbook Pro (Intel), OSX Lion, and Microsoft Exchange 2003 - NO SOLUTION
BigBossCorin (10 Hours Ago, 01:55 PM)

 


1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51