![]() |
|
#2
|
||||
|
||||
|
You can use conditional formatting to highlight cells that contain the same information as what you typed in a cell.
Select the range that contains the list of last names, then go to Home|Conditional Formatting|New Rule. Select "format only cells that contain" from top and enter cell value > is equal to > and then =$A$2 Click Format and choose from the Fill tab. Click Ok, then Ok again to apply. Now type a name in A2 and see if it hightlights the name in the list of names. |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
Conditional Row Searching
|
Kennebraun | Excel | 3 | 02-21-2018 11:02 PM |
| Mac 2011 - When I close a spreadsheet, there is a blank spreadsheet left on dock. | wvinyard | Excel | 0 | 07-27-2017 11:32 AM |
| Probably a Noob-Question: How to 'resort' a spreadsheet? | roderh | Excel | 10 | 05-09-2014 08:18 AM |
Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question
|
rsrasc | Word VBA | 7 | 03-28-2014 12:28 PM |
Searching hyperlinks
|
PuddinPie | Word | 1 | 05-27-2011 02:02 AM |