ExcelBanter - Flagging data in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Flagging data in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/177404-flagging-data-excel.html)

Rob

Flagging data in Excel

I have a query from MS Access containing user ids. In addition, I have an
excel spreadsheet containing user ids. I would like to take the results from
the Access Query and match them to the excel file and somehow flag the
matches in excel with some sort of tag (ie;color, font, etc..)

Rob Dietsche
IS Training and Development

HKaplan

Flagging data in Excel

On Feb 21, 12:44*pm, Rob wrote:
I have a query from MS Access containing user ids. *In addition, I have an
excel spreadsheet containing user ids. *I would like to take the results from
the Access Query and match them to the excel file and somehow flag the
matches in excel with some sort of tag (ie;color, font, etc..)

Rob Dietsche
IS Training and Development

You can use vlookup to match the tables, and conditional formatting to
flag matches.

All times are GMT +1. The time now is 08:19 PM.