Change background color of query results from access in worksheet

C

Chuck W

Hi,
I have Excel 2007 and selected Date => From Access and then navigated to an
Access DB and selected a query. I chose "Table" view. The query results now
appear in my worksheet which is great. However, I want to change the
background. Right now it alternatives by row between a light blue and a
darker blue. I want the results to have a white background with black
borders but have been unable to change the format. If I go to Home and
select No fill for a color background nothing happens. Is there a way to
change the query results?

Thanks,
 
G

Gord Dibben

Could be the rows are banded/colored due to Conditional Formatting.

Change the colors in CF or just clear the CF entirely.


Gord Dibben MS Excel MVP
 

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

Black Lines appearing over table borders 0
Changing row background from external program 0
Getting rid of grey background from text copied from internet 1
Layout Guide color 0
Removing Background 0
Making "Change Highlighting" feature darker 1
Printing SQL query results in a list of columns, instead of one long column 1
Change or hide Form Group Box outline 1

Top