Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Query to Excel - Format Excel Column with color

Status
Not open for further replies.

ragu111

MIS
Aug 15, 2002
129
AE
when i open the Access query in Excel (through Office Link "Analyze it with Excel" option) the data getting saved/opened in Excel file

i want a selected column's font color and back color to be in some color. (like yellow). how can i do it.

currently every time i'm holighting the column un excel. is there any way we can change the column color at the time of opening the data from access query to excel table/

ragu[pc]


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top