Quick Links ▼

Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » Searching text in range for text in another range then formattin

	98.1 % recommend us
	More live stats...

The UK's most regular
instructor-led training courses.

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions

Searching text in range for text in another range then formattin

Resolved · Low Priority · Version 2003

Reply Tue 4 Nov 2008, 10:11Delegate Yatin said...

Yatin has attended:
Excel VBA Intro Intermediate course

Searching text in range for text in another range then formattin

For example:

In Sheet1 cells A1=London, A2=Glasgow, A3=Manchester. Sheet2 Cells A1:A50 contains a list of cities/towns in the UK.

I would like my macro to go through each cell in sheet2 and search for any of the cities listed in Sheet1. If a match if found then the cell's background in Sheet2 should turn red.

Thanks

Yatin

For upcoming training course dates see: Pricing & availability

Excel articles

· Correct In, Garbage Out
· Differences In Excel 2003, 2007 And 2010
· Features of Microsoft Excel that assist in Analysis of Financial Data
· Trust Excel To Protect Your Data
· How To Use The New Excel Web App

Please browse our web site to find out more about
excel+vba+training and other Microsoft training courses.

Excel tip:

Highlighting a data range

Attempting to use a mouse to highlight a large range of cells with data in Excel can make the mouse to have a life of it's own!

Use keyboard strokes instead.

Step 1. Place the cusor in the cell where the highlighting should begin.

Step 2. Select keystroke, CTRL+SHIFT+END

This will take the cursor to the furthermost bottom corner of the data range found in that worksheet. And highlight that range of cells at the same time

View all Excel hints and tips