Automatic Color on Export to Excel

  • Thread starter Thread starter Author
  • Start date Start date
A

Author

We regularly export from Access to Excel, and it would be helpful if there
were a way to program Excel to highlight fields that contained a certain
value. If it could automatically detect when 'Check Part Number' was in the
Part Number field and highlight the cell in red, that would be pretty cool.
Any suggestions?
-Pete
 
have u tried using conditional formating. In excel, you can select the
entire column and use conditional format under the format menu path.

dmoney
 
You, sir, are correct. This is not the exact solution I was looking for as
it involves me actually manipulating the file, but it looks like the one I'll
be using. I would use a macro, but our intranet don't allow their kind in
these parts.
Muchas truchas, have a great day!
-Pete
 

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

Automatically Color Autoshape and Autoshape Naming 2
automatically highlight a row when a cell in that row is selected 4
How to type each letter of the alphabet automatically in a specific color in Word? 0
Cell.Text different from Cell.Value when dates are concerned... 3
Exporting Data to Excel 2
Export % from Excel to Word as % 1
Using cell color in conditional format makes Excel unstable 2
Color rows based on a cell value 2

Back
Top