Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #2  
Old 03-05-2018, 05:59 AM
NBVC's Avatar
NBVC NBVC is offline Searching a Spreadsheet question Windows 10 Searching a Spreadsheet question Office 2013
The Formula Guy
 
Join Date: Mar 2012
Location: Mississauga, CANADA
Posts: 215
NBVC will become famous soon enoughNBVC will become famous soon enough
Default

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.
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Searching a Spreadsheet question 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
Searching a Spreadsheet question Macro Needed to Insert Asnwer to A Question in Multiple Choice Format Question rsrasc Word VBA 7 03-28-2014 12:28 PM
Searching a Spreadsheet question Searching hyperlinks PuddinPie Word 1 05-27-2011 02:02 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 08:13 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft