Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Color on Export to Excel
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Color on Export to Excel
have u tried using conditional formating. In excel, you can select the
entire column and use conditional format under the format menu path. dmoney "Author" wrote: 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Color on Export to Excel
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 "dmoney" wrote: have u tried using conditional formating. In excel, you can select the entire column and use conditional format under the format menu path. dmoney "Author" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to change automatic color in Excel 2003 | Excel Discussion (Misc queries) | |||
Excel automatic background color | Excel Discussion (Misc queries) | |||
How do I change the AUTOMATIC color in Excel for the font? | Excel Discussion (Misc queries) | |||
Automatic color setting in Excel | Excel Discussion (Misc queries) | |||
HOW DO I CHANGE THE AUTOMATIC BORDER COLOR IN EXCEL? | Excel Worksheet Functions |