Flagging data in Excel

  • Thread starter Thread starter Rob
  • Start date Start date
R

Rob

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
 
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 resultsfrom
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
Click to expand...

You can use vlookup to match the tables, and conditional formatting to
flag matches.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 Problem Paste/Enter Key 0
Opening excel 2010 spreadsheet from Access 4
Access #Error & Excel Pivot 0
Renaming excel file with autonumber in MS Access 0
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Excel Query setup 0
Best method / software for graphical output from dynamic excel data 0
Flagging Up Stock On Excel 2000 2

Back
Top