Using Key Words to Sift??

[haniyyahglenn]

I have a project in excel with over 5000 records. I need to seperate and highlight records containing certain key words (town, city, borough etc.) How do i go about doing this without reading each individual record?

[ChemistB]

You can use Conditional Formatting. Since you are on 2003, there's a limit of 3 colors. I assume that the keywords would be in a certain column, let's say Column C and your data goes from A2:F5000.

Highlight/select your data range. Go to conditional formatting
Select "Formula is"

Please Login or Register  to view this content.

and select a formatting (e.g. turn cells green). Then repeat with a different formatting for a second and third keyword.

If you have more than 3, you can combine similar keywords into 1 format with OR

Please Login or Register  to view this content.

Does that work for you?

[Palmetto]

Seems to be a job for Advanced Filter with criteria and filtering in place or, optionally, using the option to copy to another location.